MySQL SQLYOG import CSV data failed to do?

Share the solution to the failure of MySQL to import CSV data using SQLyog

Import data to MySQL, select a table Select Import--Import using local CSV data can, single time do not know what problem import is not successful!!!

To MySQL import data, the use of the software is SQLyog, I believe that the direct guide everyone will also, select a table Select Import-Import using local CSV data can, single time do not know what problems import is not successful, you can use commands to this record, later used for easy to check:

(My 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
) www.jbxue.com
Attention:
1.csv files are generally GBK encoded in Chinese, so this setting is encoded as GBK
2. The field name in parentheses