SELECT col1, col2, col3, ...
FROM some_table
INTO OUTFILE '/tmp/some_table.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'