1
2
3
4
5
6
select my_columns 
into outfile '/tmp/results.csv'
fields terminated by ',' optionally enclosed by '"'
escaped by '\\'
lines terminated by '\n'
from my_table;