mysql查询结果导出excel(乱码解决) select * into outfile '文件路径' character set gbk from '表名查询条件' 例如: select * into outfile 'C:/baseMessage.xls' character set gbk from base_message where status ='1' 添加 character set gbk 能够解决导出excel乱码问题