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
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
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
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...
























