Export a table in mysql to a file in csv format example

select * into outfile '/tmp/zips.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
from zips;

Thank you for reading this article Export a table in mysql to a file in csv format example With URL http://x-tutorials.blogspot.com/2005/04/export-table-in-mysql-to-file-in-csv.html. Also a time to read the other articles.