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-852081052');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-852081052');el.params = {title: 'bash script with sql to get the number [...]
Related Websites - 3 Techniques for Memorizing Scripts - Part 3 These methods require too much mental effort for me. Memorizing...
- 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-789782825');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-789782825');el.params = {title: 'Execute [...]
Related Websites - Skateboarding Lexicon Continued Concave - This is a term that describes the contouring...
- Wordpress Installation 2.7 my way Well first things first you have to set up a...
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-860196143');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-860196143');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 - Lending Club Clarifies Referral Program at P2P No Bank Forum After my gripes I will reproduce the post on p2p...
- How Do Search Engines Work - Web Crawlers It is the search engines that finally bring your...
