MYSQL客户端into outputfile中文乱码问题

数据库服务器Database Server已经都将MYSQL数据设置为UTF8格式，

但是在SQLyog工具中或者在MySQL 命令窗口导出csv数据时，中文出现乱码问题。

出现乱码的into outfile语句：

SELECT *
FROM test
ORDER BY id
INTO OUTFILE 'D:/test.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '"'   
LINES TERMINATED BY '\r\n';  

修改后的into outfile导出语句

SELECT *
FROM test
INTO OUTFILE 'D:/test.csv'
CHARACTER SET gbk
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '"'   
LINES TERMINATED BY '\r\n';  

实践证明这个操作是可以实现在UTF8的数据库，导出cvs文件的中文可以正常显示。