1、创建database和table
2、
load data infile 'E:/baiduyundownload/400W-600W.csv'
into table kfinfo
fields terminated by ','
optionally enclosed by '"'
lines terminated by '\r\n'
ignore 1 lines
(name , cardno , descriot , ctftp , ctfid , gender , birthday , address , zip ,
dirty , district1 , district2 , district3 , district4 , district5 , district6 ,
firstnm , lastnm , duty , mobile , tel , fax , email , nation , taste ,
education , company , ctel , caddress , czip , family , version , id );
将上面的命令保存到tmp.sql下,在mysql命令行下执行
source tmp.sql
即可。
问题:
在导入完成后,有时会出现worring,以后注意一下吧。