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"
uj5u.com熱心網友回復：
知道了，ENCLOSED BY '""' 改成 ENCLOSED BY ''就可以了uj5u.com熱心網友回復：
ENCLOSED BY '""' 改成 ENCLOSED BY ''uj5u.com熱心網友回復：
少了輸出檔案，命令后面加入 >> test.csv轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/92411.html
標籤：MySQL
上一篇：困擾了很久的模糊查詢問題
下一篇：volatile的兩大性質