mysql批量导入，导出

导入

load data local infile 'D:\data.csv' into table user fields terminated by ',' lines terminated by '\r\n';

指定各列之间的分隔符为‘，’,而行之间的分隔符为‘\r\n’。

load data local infile 'D:\data.csv' into table user fields terminated by ',' enclosed by '"' lines terminated by '\r\n' ignore 1 lines;

指定各列之间的分隔符为‘，’并在每个字段前后添加“,而行之间的分隔符为‘\r\n’，并忽略第一行

导出

select * from user into outfile 'd:\data.csv' fields terminated by ',' lines terminated by '\r\n';

指定各列之间的分隔符为‘，’而行之间的分隔符为‘\r\n’。

select * from user into outfile 'd:\data1.csv' fields terminated by ',' enclosed by '"' lines terminated by '\r\n';

指定各列之间的分隔符为‘，’并在每个字段前后添加“,而行之间的分隔符为‘\r\n’。