[PHP] MySQL to csv

2002-08-15 Thread Djurovski Dejan
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

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

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: ? // untested // get each row of the table into a a var, // separated by commas, ended with \n $csv_contents = '';

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! -- PHP General

[PHP] mysql to .csv file

2002-05-14 Thread Amit Singh
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