BAT文件无法导出CSV

[lxq19851204]

Select b.barcode as barcode,sum(b.qty) as qty into outfile 'D:/backup/1.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' From trans a join transdetail b on a.transid=b.transid where a.businessdate= date_add(curdate(),interval -1 day) and a.transstatus=2 group by b.barcode

这段代码运行在MYSQL上是可以导出CSV的，
我放到BAT中，就无法导出：
cd C:\Program Files (x86)\MySQL\MySQL Server 5.0\bin

"C:\Program Files (x86)\MySQL\MySQL Server 5.0\bin\mysql" -uroot -ppassword blank -N -e "Select b.barcode as barcode,sum(b.qty) as qty into outfile 'D:/backup/1.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '""' LINES TERMINATED BY '\n' From trans a join transdetail b on a.transid=b.transid where a.businessdate= date_add(curdate(),interval -1 day) and a.transstatus=2 and b.itemstatus<>1 group by b.barcode"

[lxq19851204]

知道了，ENCLOSED BY '""' 改成 ENCLOSED BY ''就可以了

[crynono]

ENCLOSED BY '""' 改成 ENCLOSED BY ''

[o前男友o]

少了输出文件，命令后面加入 >> test.csv