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: 4

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 P