MySql csv文件导入导出

导入
load data infile '/www/user_reports.csv' into table records fields terminated by ',' optionally enclosed by '"' escaped by '"' lines terminated by '\r\n';
导出
select * from records into outfile '/www/tmp/user_reports.csv' fields terminated by ',' optionally enclosed by '"' escaped by '"' lines terminated by '\r\n';