Roland Turner

about | contact

MySQL, writing to a CSV file

Why these aren’t default options I can’t imagine…

SELECT {{whatever}}

INTO OUTFILE ‘filename’

FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘”‘

LINES TERMINATED BY ‘\n’;