Hi
Can someone show me how to export MySQL table to a csv file?
Thanks!
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[snip]
Can someone show me how to export MySQL table to a csv file?
[/snip]
From http://www.mysql.com/doc/en/SELECT.html
The SELECT ... INTO OUTFILE 'file_name' form of SELECT writes the selected
rows to a file. The file is created on the server host and cannot already
exist (among other
Assuming that you KNOW the structure of the table, this should do it... if
you needed something more open-ended to cope with ANY table, I'd have to
think about it a little more:
? // untested
// get each row of the table into a a var,
// separated by commas, ended with \n
$csv_contents = '';
Using SQL or PHP?
-Original Message-
From: Djurovski Dejan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 15, 2002 11:42 AM
To: [EMAIL PROTECTED]
Subject: [PHP] MySQL to csv
Hi
Can someone show me how to export MySQL table to a csv file?
Thanks!
--
PHP General
Hi Folks,
I m trying to export data from mysql using 'SELECT * INTO
OUTFILE...' query into a '.csv' file.
It does happen successfully but I don't get the field values
(having commas or enter characters)enclosed in double/single
quotes.
Is there a way out to accomplish this?
If yes, please
5 matches
Mail list logo