Lairds Computer Services

To export data from a select query to a csv file, you use the following style of select query:

select * from mytable
into outfile '/var/lib/mysql/outfile.csv'
fields terminated by ','
enclosed by '"'
lines terminated by '\n';

where your output will end up in /var/lib/mysql/outfile.csv.