On 29 Oct 2004, at 00:37, Mulley, Nikhil wrote:
How do I dump the data from console to the text file from the output
generated by SELECT statement ?
If it's a small answer that you're just trying to save to a file for
note-keeping purposes, you could run
mysql -e 'select * from thing where
Hi List,
How do I dump the data from console to the text file from the output generated by
SELECT statement ?
Thanks,
Nikhil.
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