please look at my code

chynna_v · 09-05-2004, 10:10 PM

i have this code...

#!/bin/sh

DBS=`echo "select count(*) from out where bfr_id=60 and status=0" | mysql -uroot`
echo $DBS

and the output is
count(*) 5000

but i just wanted to get the value of the count in the actual database and not with the word "count(*)" in it...so i will be able to manipulate the value..im trying to write a script where it can echo the number of count in the database until the value is 0 then it will exit..how can i achieve this? any help will be appreciated.. thanks!

zipster · 09-05-2004, 10:26 PM

Quote:

Originally posted by chynna_v
i have this code...

#!/bin/sh

DBS=`echo "select count(*) from out where bfr_id=60 and status=0" | mysql -uroot`
echo $DBS

and the output is
count(*) 5000

but i just wanted to get the value of the count in the actual database and not with the word "count(*)" in it...so i will be able to manipulate the value..im trying to write a script where it can echo the number of count in the database until the value is 0 then it will exit..how can i achieve this? any help will be appreciated.. thanks!

Try changing the first line to be:

Code:

DBS=`echo "select count(*) from out where bfr_id=60 and status=0" | mysql -uroot | cut -d" " -f 2`

or something similar

God Bless

Zipster

chynna_v · 09-05-2004, 10:54 PM

the output is still the same...

Hko · 09-06-2004, 12:48 PM

Just use the -s option for mysql:

.... | mysql -s -uroot

chynna_v · 09-06-2004, 08:22 PM

Hi hiko! it worked! thanks a bunch!!!

tried the whole day manipulating the code with the cut command...and just a simple "-s" did the thing!

but i would also like to thank zipster because w/o him also i wouldn't be familiarze with the "cut"..very useful indeed