逗号分隔值(Comma-Separated Values,CSV),要点有:
(1)字段之间以,(英文逗号)间隔
(2)数据行之间使用\r\n分隔
MySQL写入CSV:
load data infile 'path' into table tbl_name (set character utf8) fields terminated by ',' lines terminated by '\r\n';
MySQL写出CSV:
select * from tbl_name into outfile 'PATH' fields terminated by ',' lines terminated by '\r\n';
这段代码中涉及的一些关键字的解释如下:
fields terminated by ”:这是指出csv文件中字段终止符,也就是数据之间的分隔符;
lines terminated by ”:指行终止符