Mysql uses SQLyog to import CSV data unsuccessful solutions _mysql

Today to the MySQL import data, the use of software is SQLyog, I believe that direct guide everyone will also be selected to select a table to import-import use of local CSV data can be, single sometimes do not know what problems import is not successful, you can use the command to this record, later used to facilitate the search:

(Mine is the Windows system)

LOAD DATA local INFILE ' c:\\users\\zl\\desktop\\zhishu.csv ' into
table library name. Table name CHARACTER SET GBK 
FIELDS terminated By ', ' optionally enclosed by ' "' escaped by '" ' 
LINES terminated by ' \ r \ n ' (
ID, 
' name ', '
description ', 
  parent_id
)

Attention:

1.csv files are generally Chinese GBK encoding, so the encoding is set here as GBK
2. The name of the field in parentheses