Mysql Import Export CSV Chinese problem solving method _mysql

Import CSV:

Copy Code code as follows:

Load data infile '/test.csv ' into table table_name
Fields terminated by ', ' optionally
Enclosed by ' "' escaped by '"
Lines terminated by ' \ r \ n '
Ignore 1 lines;

Guide CSV:

Copy Code code as follows:

SELECT * into outfile '/test.csv '
FIELDS terminated by ', ' optionally
Enclosed by ' "'
LINES terminated by ' \ n '
from table_name;

Resolve export CSV Chinese garbled problem:

CSV with TXT open, save As, select UTF8 encoding can be.

To resolve the import issue:

My.ini under the MySQL installation directory, add the following parameters:

[Client]
Default-character-set=utf8

[Mysqld]
Default-storage-engine=innodb
Character-set-server=utf8
Collation-server=utf8_general_ci

Restart the MySQL service.