Linux and Photography Blog
Database
bash script with sql to get the number of records from multiple tables.
Feb 10th
bash script with sql to get the number of records from multiple tables.
Hot:
Here is the bash script:
#!/bin/sh
names[1]=errorlog
names[2]=amit1log
names[3]=amit2log
names[4]=amit3log
names[5]=amit4log
j=1
echo $1
for i in $( sqlplus amit/passwd@tns @get_count.sql |sed -n ‘/COUNT/,/Disconnected/p’|sed ‘/COUNT/ d’|sed ‘/—/ d’|sed ‘/Disconnected/ d’|tr ‘n’ ‘ ‘ )
do
temp=${names[$j]}
let count=30-${#temp}
for ((I=1; I <= $count ; I++))
do
printf ” ”
done
echo “${names[$j]} : $i”
# echo $j
let j=j+1
done
echo
echo
More >
Sharevar el = document.getElementById('share-link-202716638');el.params = {title: 'bash script with sql to get the number [...]
Related Websites
Hot:
Here is the bash script:
#!/bin/sh
names[1]=errorlog
names[2]=amit1log
names[3]=amit2log
names[4]=amit3log
names[5]=amit4log
j=1
echo $1
for i in $( sqlplus amit/passwd@tns @get_count.sql |sed -n ‘/COUNT/,/Disconnected/p’|sed ‘/COUNT/ d’|sed ‘/—/ d’|sed ‘/Disconnected/ d’|tr ‘n’ ‘ ‘ )
do
temp=${names[$j]}
let count=30-${#temp}
for ((I=1; I <= $count ; I++))
do
printf ” ”
done
echo “${names[$j]} : $i”
# echo $j
let j=j+1
done
echo
echo
More >
Sharevar el = document.getElementById('share-link-202716638');el.params = {title: 'bash script with sql to get the number [...]
Related Websites - Blog Carnival vs Blogroll A blogroll is a list of blogs that is usually...
- Using the Create Names From Selection dialog box You may have a worksheet that contains text that you...
Execute mysql command from shell
Feb 4th
Execute mysql command from shell
Hot:
phpMyAdmin is a very slow application if you want to execute a query on your database. If you know the name of the database then any GUI tool is an overhead. So I have written a one liner shell script to do that for me
More >
Sharevar el = document.getElementById('share-link-417756604');el.params = {title: 'Execute [...]
Related Websites
Hot:
phpMyAdmin is a very slow application if you want to execute a query on your database. If you know the name of the database then any GUI tool is an overhead. So I have written a one liner shell script to do that for me
More >
Sharevar el = document.getElementById('share-link-417756604');el.params = {title: 'Execute [...]
Related Websites - Skateboarding Lexicon Continued Concave - This is a term that describes the contouring...
- Related Tweets Using your blog as the seed, find quality content from...
Using PHP to search a MySQL database and return paged results
Dec 4th
Using PHP to search a MySQL database and return paged results
Hot:
Using PHP to search a MySQL database and return paged results
More >
Sharevar el = document.getElementById('share-link-548752180');el.params = {title: 'Using PHP to search a MySQL database and return paged results', link: 'http://blog.amit-agarwal.co.in/2009/12/04/using-php-to-search-a-mysql-database-and-return-paged-results/', skin: 'blue', content: 'http://blog.amit-agarwal.co.in/?ibsa=get_content&id=154'};Originally posted 2008-10-19 20:17:30.
Related Websites
Hot:
Using PHP to search a MySQL database and return paged results
More >
Sharevar el = document.getElementById('share-link-548752180');el.params = {title: 'Using PHP to search a MySQL database and return paged results', link: 'http://blog.amit-agarwal.co.in/2009/12/04/using-php-to-search-a-mysql-database-and-return-paged-results/', skin: 'blue', content: 'http://blog.amit-agarwal.co.in/?ibsa=get_content&id=154'};Originally posted 2008-10-19 20:17:30.
Related Websites - Search Engine Optimisation Pitfalls On page factors - Is your website search engine friendly?...
- Three ways to find a cool deal using Google (This guest post is by Ann Smarty, a search engine...
