RE: [PHP] MySQL to csv

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 ta

Re: [PHP] MySQL to csv

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: This is all off the top of my head, untested, with snippets lifted from the manual, but it should give u the theory,

RE: [PHP] MySQL to csv

[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 things

[PHP] MySQL to csv

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

[PHP] mysql to .csv file

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 help.