Export To CSV

[lintz]

Is it possible to export the results of a query to a CSV file?

If so, does anyone have an example?

[john tindell]

You have to do it yourself, so just loop though each value and each record and write them to a file with the delimator ',' or ';' splitting them up.

[lintz]

Thanks John, I thought that would be the solution.

[visualAd]

In mysql you can do it with a query:

SELECT * INTO OUTFILE 'c:\path\to\csv.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'
FROM table_name;

[anjanesh]

lintz - better still - use PHP5's fputcsv (http://in.php.net/manual/en/function.fputcsv.php)