> mysql -e "select * from table" database > output.txt
or if you're looking for more of a log of what happened in the MySQL client, from the MySQL shell:
> tee output.txt > select * from table;
Mulley, Nikhil wrote:
Hi List,
How do I dump the data from console to the text file from the output generated by SELECT statement ?
Thanks,
Nikhil.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]