文件类型是utf8想导入到mysql (utf8)中,如下语句:
load data local infile 'c:/data/5000.csv' into table KF character set utf8 fields terminated by ',' lines terminated by '\r\n' ignore 1 lines;
或者将字符集改成ansi再导入
文件类型是utf8想导入到mysql (utf8)中,如下语句:
load data local infile 'c:/data/5000.csv' into table KF character set utf8 fields terminated by ',' lines terminated by '\r\n' ignore 1 lines;
或者将字符集改成ansi再导入