The problem with below statement is that, if i there is any error in sql statements it does not get written to aaaa1.txt. So, even if there is any error, how can i get it written to aaaa1.txt.
mysql -uroot -pxxx -Dtest -s -e 'select * from amc_25;' > aaaa1.txt On 7/29/08, Mary Bahrami <[EMAIL PROTECTED]> wrote: > > I use > mysql -uroot -pxxx -Dtest -s -e 'select * from amc_25;' > aaaa1.txt > > but it would be nice to see other solutions... > > > -----Original Message----- > From: Ananda Kumar [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 29, 2008 6:37 AM > To: mysql > Subject: spool log to a file > > Hi All, > I am executing below command, but there is no entires in aaaa1.txt, its > an > empty file. How can i write the logs into this file. > > mysql -uroot -pxxx -Dtest -s --tee=aaaa1.txt -e 'select * from > amc_25;' > > regards > anandkl >