Mysql 导入导出csv 中文乱码问题的解决方法

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;      

导csv：

SELECT * INTO OUTFILE '/test.csv'
FIELDS TERMINATED BY ',' OPTIONALLY
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM table_name;
      

解决导出csv中文乱码问题：

将csv用txt打开，另存为，选择utf8编码即可。

解决导入问题：

http://www.unitymanual.com  unity3d

mysql安装目录下的my.ini，增加如下参数：

[client]

default-character-set=utf8