RE: [PHP] MySQL to csv

2002-08-15 Thread Brian V Bonini
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! > > > > -

Re: [PHP] MySQL to csv

2002-08-15 Thread Justin French
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

2002-08-15 Thread Jay Blanchard
[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