How do I export a MySQL table to a .csv file?

Share

Tweet

Share

Share

Email

Comments

select * into outfile ‘/tmp/table.csv’ FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘”‘
LINES TERMINATED BY ‘\n’
from mytable;