SELECT ... INTO OUTFILE '/tmp/mycsvfile.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY 'n';