ALTER TABLE nian_16 CONVERT TO CHARACTER SET gbk COLLATE gbk_chinese_ci;
load data infile 'C:/ProgramData/MySQL/MySQL Server 5.7/Uploads/wokek.csv' into table nian_16
character set gbk
fields terminated by ','
optionally enclosed by '"'
escaped by '"'
lines terminated by '\r\n'
ignore 1 lines;
load data infile 'C:/ProgramData/MySQL/MySQL Server 5.7/Uploads/wokek.csv' into table nian_16
character set gbk
fields terminated by ','
optionally enclosed by '"'
escaped by '"'
lines terminated by '\r\n'
ignore 1 lines;