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




-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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