I am executing a mysql query through shell and expecting to see a return of SQL 
execution. 

mysql -D $dbName --vertical -u $DBUSER -p$DBPASS < $queryFile > $opFile
rc=$?

Here rc is always 0 and so are $opFile entries. $queryFile contains exactly the 
same query as listed below.


If the same query is run in mysql client, I see the result as "Empty set (0.00 
sec)". Why don't I get a return in shell.

mysql> select * from usrtbl where username='vou_0004016';
Empty set (0.00 sec)


Thanks,

Nupur
___________________________________________________________
Sign-up for Ads Free at Mail.com
http://promo.mail.com/adsfreejump.htm


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to