How to export MYSQL to CSV

By Doug on August 2, 2006 7:14 PM | No Comments

Simply execute

SELECT <fields or *> INTO OUTFILE '/tmp/result.text'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM <table> WHERE <condition>