MySQL导出Excel

MySQL导出Excel：

echo "set names 'utf8';SELECT XX,SUM(NJ_ALL) 全部,SUM(NJ_2013) 高一,SUM(NJ_2012) 高二,SUM(NJ_2011) 高三,SUM(NJ_NULL) 未知 FROM (SELECT XX, 1 AS NJ_ALL,(case when NJXX_ID='2011' then 1 else 0 end) as NJ_2011,(case when NJXX_ID='2012' then 1 else 0 end) as NJ_2012,(case when NJXX_ID='2013' then 1 else 0 end) as NJ_2013, (case when NJXX_ID is null then 1 else 0 end) as NJ_NULL FROM TB_CHECK_STUDENT ) T GROUP BY T.XX" | mysql -h192.168.10.101 -uwebuser -pwebuser@123 WEIXIN > /tmp/test.xls

字符集转码：

iconv -futf8 -tgb2312 -otest2.xls test.xls