导入
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’。