Exporting a Mysql table to a CSV file
Friday, July 25th, 2008select * into outfile ‘temp.csv’
fields terminated by ‘,’ optionally enclosed by ‘”‘
lines terminated by ‘\n’
from tablename;
File outputs in:
/var/lib/mysql/tablename/temp.csv
select * into outfile ‘temp.csv’
fields terminated by ‘,’ optionally enclosed by ‘”‘
lines terminated by ‘\n’
from tablename;
File outputs in:
/var/lib/mysql/tablename/temp.csv