Re: Output to a file

On 5/5/06, Rhino [EMAIL PROTECTED] wrote: - Original Message - From: Payne [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, May 05, 2006 12:09 AM Subject: Output to a file Hey, been trying to output a select statment to a file, all the books I have only show how to input

Re: Output to a file

- Original Message - From: Payne [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, May 05, 2006 12:09 AM Subject: Output to a file Hey, been trying to output a select statment to a file, all the books I have only show how to input from a file, what is the correct way

Output to a file

Hey, been trying to output a select statment to a file, all the books I have only show how to input from a file, what is the correct way I thought I could do select * from my_toy `/tmp/my_toys` But I get an error. Payne -- MySQL General Mailing List For list archives:

Re: Output to a file

Payne wrote: Hey, been trying to output a select statment to a file, all the books I have only show how to input from a file, what is the correct way I thought I could do select * from my_toy `/tmp/my_toys` But I get an error. Payne You can use the 'tee' command, eg: tee

Re: Output to a file

Hi Payne. Payne wrote: Hey, been trying to output a select statment to a file, all the books I have only show how to input from a file, what is the correct way I thought I could do select * from my_toy `/tmp/my_toys` You can do 'select * into outfile from table name;' But I get

output in text file /migration

Hi, I want to migrate 1 table from MYSQL to oracle ? how to do that ? How to get output of table into text file? thanks . - Yahoo! Mail Mobile Take Yahoo! Mail with you! Check email on your mobile phone.

Re: output in text file /migration

As for your second question, SELECT INTO OUTFILE (making sure mysql user has write privileges in the directory/file you want to write to). MySQL give the example: SELECT a,b,a+b INTO OUTFILE '/tmp/result.text' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' LINES TERMINATED BY '\n' FROM

Redirect output to the file

I want to redirect output of the query to the file in tab delimited format. Can this be done? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Redirect output to the file

Jerry Swanson wrote: I want to redirect output of the query to the file in tab delimited format. Can this be done? Thanks Select ... INTO OUTFILE: http://dev.mysql.com/doc/mysql/en/SELECT.html or mysql -e (documentation on the same page) HTH, Wolfram -- MySQL General Mailing List For list

re: Output data to file

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:

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:

Re: Output data to file

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

Output to a file?

Hello, I'm new to MySQL. I've been able to query the database via PHP and display it within a html page. I would like to out put the results to a flat file tab delimited instead of onto a new page. Thanks for any help. DBA / Unix Administrator Patrick Fowler Wynit, Inc. 6847 Ellicott Drive

re: Output to a file?

Patrick, Thursday, September 26, 2002, 3:38:24 PM, you wrote: PF I'm new to MySQL. I've been able to query the database via PHP and display PF it within a html page. I would like to out put the results to a flat file PF tab delimited instead of onto a new page. Use SELECT INTO OUTFILE:

redirect output to a file?

Hi, WIth the way eSKUeL (a PHP app I found on freshmeat) displays query results in a table, and the way that copying and pasting that data into a xls or doc file appears I'm hoping to be able to run queries manually on the mysql prompt and have the output redirected to a file so that I'm able

RE: redirect output to a file?

[mailto:[EMAIL PROTECTED]] Sent: Sunday, July 14, 2002 5:53 PM To: [EMAIL PROTECTED] Subject: redirect output to a file? Hi, WIth the way eSKUeL (a PHP app I found on freshmeat) displays query results in a table, and the way that copying and pasting that data into a xls or doc file appears I'm hoping

output to a file

Hey Guys, I know this is more of a PHP question, but since most people here now a lot about PHP I thought I'd ask. I have a script that outputs headlines for reviews and I need to output it to a file for inserting into my page, because I can't use php on this specific page so I want to output