MySQL sqlyog import and export CSV file

1. Select database table--Right-click Properties--Backup/Export--export table data as---Select CVS--Select the following "Change"--field--Variable length--the field is terminated --Enter a comma, ( This is the focus, otherwise the contents of the exported CSV file are in one column, not the sub-field )
The following two options boxes are canceled.

2. after exporting the CSV file, use the UE editor to open, save as, select Encode to Utf-8 format, save.

3. Open the CSV file, so that Chinese is the correct display, if not transcoding save, for Chinese garbled.

4. Select database table--Import--import locally available CSV data--Import from file, select just CSV file, import complete.

MySQL sqlyog import and export CSV file