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 PROTECTED]> To: MySql <[EMAIL PROTECTED]> Sent: Monday, March 24, 2003 11:09 AM Subject: Output data to file > I want to send the results of > Select name, email from messages > To a plain text file, how can I do this? > > Once I am in the mysql prompt, I can not issue normal shell commands, thanks > > ------------------------------------------------------------- > Scott Haneda Tel: 415.898.2602 > http://www.newgeo.com Fax: 313.557.5052 > [EMAIL PROTECTED] Novato, CA U.S.A. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]