Ever needed to export data from MySQL into a CSV file? Its actually fairly simple,
SELECT * INTO OUTFILE ‘/tmp/name.csv’
FIELDS TERMINATED BY ‘,’
OPTIONALLY ENCLOSED BY ‘”‘
ESCAPED BY ‘\\’
LINES TERMINATED BY ‘\n’
FROM [tablename]Certainly easier then writing a quick Python/Perl/PHP script to do the job.
Posts Tagged "cvs"
MySQL Export to CSV File
December 26th, 2011
{ Comments }