Import csv data to mysql, and import csv data to mysql

Import csv data to mysql, and import csv data to mysql

The csv table contains Chinese characters. The specific implementation code is as follows:

Load data infile 'C: \ Users \ Administrator \ Desktop \ import \ CELLutf.csv 'into table cell character set gbk (set gbk character encoding to prevent Chinese garbled characters)
Fields terminated ','
Enclosed '"'
Lines terminated by '\ r \ N'
IGNORE 1 LINES;

Code explanation:

Fields terminated by ',': delimiter between data in csv files. csv files are separated by commas by default;

Enclosed by '': Specifies the envelope character;

Lines terminated by '': indicates the line terminator;

IGNORE 1 LINES: IGNORE the csv header.