re: Output data to file

2003-03-24 Thread Egor Egorov
On Monday 24 March 2003 06:09, Scott Haneda wrote: I want to send the results of Select name, email from messages To a plain text file, how can I do this? The solution: SELECT name,email FROM messages INTO OUTFILE '/tmp/my-file-name'; Scott HanedaTel:

Re: Output data to file

2003-03-23 Thread Ivan Paul
hi... pls try this... mysql \T c:\result.txt mysql select name, email from messages; after command executed... you can use this command to stop print result to file. mysql \t; mysql have a nice try :-) Ivan Paul MySQL, Query - Original Message - From: Scott Haneda [EMAIL