How does mysql import csv data using SQLyog fail? _ MySQL

To import data to mysql, select a table and select Import-import to use the local csv data. if you do not know the problem, the data cannot be imported to mysql. the software used is SQLyog, I believe that you will also select a table and select Import-import to use the local csv data. if you do not know the problem, you can use the command to record it, for future use:

(My windows OS)

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' "'elasticed BY '" 'lines terminated by' \ r \ n' (id, 'name ', 'Description', parent_id)

Note:

Files in 1.csv are generally encoded in gbk. Therefore, the encoding is set to gbk.
2. the field name is enclosed in brackets.