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
neda <[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 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.8