导⼊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编码即可。解决导⼊问题：
mysql安装⽬录下的my.ini，增加如下参数：[client]
default-character-set=utf8[mysqld]
default-storage-engine=INNODBcharacter-set-server=utf8
collation-server=utf8_general_ci重启mysql服务。
因篇幅问题不能全部显示，请点此查看更多更全内容