"Command not found" error using expr in shell script

Harish sharma · 11-08-2012, 04:33 AM

Quote:

Originally Posted by chrism01

Show your real query..

In any case, you'll need to convert the NULL into zero if you want to do arithmetic on it.
(see my point 2. above)

Try IFNULL() as demonstrated here http://stackoverflow.com/questions/1...ting-null-to-0

You really need to bookmark and read https://dev.mysql.com/doc/refman/5.1/en/

Hi ,

subscription=$(mysql -D $DBDATABASE -u $DBUSER -p$DBPASSWORD -e "select sum(price) from price");
renew=$(mysql -D $DBDATABASE -u $DBUSER -p$DBPASSWORD -e "select sum(price) from boxprice");

this subcription query giving me null response and renew query giving 50 and want to sum these and want result 50..
Hope u will understand my query..

Thanx a lot

chrism01 · 11-08-2012, 04:40 AM

There's no point in repeating your qn.
Read my answer; read those links

(Please)

Harish sharma · 11-08-2012, 05:53 AM

Quote:

Originally Posted by chrism01

Show your real query..

In any case, you'll need to convert the NULL into zero if you want to do arithmetic on it.
(see my point 2. above)

Try IFNULL() as demonstrated here http://stackoverflow.com/questions/1...ting-null-to-0

You really need to bookmark and read https://dev.mysql.com/doc/refman/5.1/en/

Hi chrism01,
it's working i was in wrong direction...

I checked null in query after that results 0 than I able to sum these variable..
Thanx Again