mysql,查询后导出txt,如何把字段名也导出啊,百度也找不到,正文有语句,大家看看。
大家帮我看看,导出到txt后,没有wq5.`XINGJI`,sum(wq5.`DQYE`) 这两个字段,只有结果。。。
select wq5.`XINGJI`,sum(wq5.`DQYE`) from wq5 group by wq5.`XINGJI` INTO OUTFILE 'e:/sfdgg1.txt' FIELDS TERMINATED BY '\t';
以下是我在百度找的,但是套进去用不成啊。
select wq5.`XINGJI`,sum(wq5.`DQYE`) from wq5 group by wq5.`XINGJI` (SELECT 'XINGJI','sum(wq5.DQYE)' UNION ALL select wq5.`XINGJI`,sum(wq5.`DQYE`) from wq5 group by wq5.`XINGJI`)a INTO OUTFILE 'e:/sfdgg1.txt' FIELDS TERMINATED BY '\t';
大家帮我一下,谢谢啊!