怎么把csv文件导入mysql

Question

如题所述

Answer 1

load data infile '/tmp/file.csv' into table _tablename (set character utf8)
fields terminated by ','
enclosed by '"'
lines terminated by '\r\n';
这段代码中涉及的一些关键字的解释如下：
fields terminated by '':这是指出csv文件中字段终止符，也就是数据之间的分隔符；
enclosed by '':指出封套符；
lines terminated by '':指行终止符