Import csv data into mysql with Chinese characters

demo

prety simple but expended my lots time.
Here it is.

1. LOAD DATA LOCAL INFILE 'H:/Data/data1.csv' INTO TABLE crc_students_1
   
2. CHARACTER SET 'GBk'
   
3.   FIELDS TERMINATED BY ',' ENCLOSED BY '"'
   
4. # ESCAPED BY '\\'
   
5.   LINES TERMINATED BY '\r\n'
   
6.   IGNORE 1 LINES;

复制代码

Please note: character set may be GB2312, UTF8, BIG5, or other code. you can see the details using:

SHOW COLLATION