that is a shell question using bash/ksh stuff you can use this: mysql -uroot -pxxx -Dtest -s -e 'select * from amc_25;' > aaaa1.txt 2>&1
Ananda Kumar wrote: > 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 >> > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]