There are several ways to get output to a text file, from the Unix shell you can:

> 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]



Reply via email to