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
- 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
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:
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
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
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.
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
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]
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
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:
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:
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
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
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:
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
[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
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
17 matches
Mail list logo