mysql> select concat(A.TransID,'-',A.itemID) as detail_uid,A.itemID as line_no,B
.StockCode as item_uid,C.TermID as location_uid,A.qty as quantity,A.unit as uom_
uid,A.price as unit_price,A.ManualDisc as discount,A.TotalmemberDisc as sales_li
ne_discount From TransDetail A join inventory B on A.Barcode=B.Barcode jOIN Tran
s C on C.transid=A.Transid where c.BUSINESSDATE='2012-07-18' AND a.ItemStatus=0;ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 222
Current database: 211+------------+---------+------------+--------------+----------+---------+-------
-----+----------+---------------------+
| detail_uid | line_no | item_uid | location_uid | quantity | uom_uid | unit_p
rice | discount | sales_line_discount |
+------------+---------+------------+--------------+----------+---------+-------
-----+----------+---------------------+
| 5793-1 | 1 | 123457866 | 1 | 1 | PCS | 7.
9000 | 0.0000 | 0.0000 |
| 5793-2 | 2 | jkefkenkfj | 1 | 1 | PCS | 5.
8000 | 0.0000 | 0.0000 |
| 5793-3 | 3 | a1b2c3 | 1 | 1 | PCS | 10.
0000 | 0.0000 | 0.0000 |
| 5794-1 | 1 | 123457866 | 1 | 1 | PCS | 7.
9000 | 0.0000 | 0.0000 |
| 5794-2 | 2 | jkefkenkfj | 1 | 1 | PCS | 5.
8000 | 0.0000 | 0.0000 |
| 5795-1 | 1 | 1234567 | 1 | 1 | PCS | 16.
8000 | 0.0000 | 3.3600 |
| 5795-2 | 2 | abcdefg | 1 | 1 | PCS | 16.
8000 | 1.6800 | 3.0200 |
+------------+---------+------------+--------------+----------+---------+-------
-----+----------+---------------------+
7 rows in set (0.20 sec)mysql>"select concat(A.TransID,'-',A.itemID) as detail_uid,A.itemID as line_no,B.StockCode as item_uid,C.TermID as location_uid,A.qty as quantity,A.unit as uom_uid,A.price as unit_price,A.ManualDisc as discount,A.TotalmemberDisc as sales_line_discount From TransDetail A join inventory B on A.Barcode=B.Barcode jOIN Trans C on C.transid=A.Transid where c.BUSINESSDATE='2012-07-18' AND a.ItemStatus=0 " > c:\\2.XLS用命令导出,其中第一列的EXCEL数据打开格式为日期形式5793-01-01,用MYSQL自带的工具导出是没有问题的。
结果如何
结果如何
而正确的格式是5793-1,5793-2这样的。concat('''',A.TransID,'-',A.itemID) 这样的话出来的效果是'5793-1,'5793-2
CAST(concat('''',A.TransID,'-',A.itemID) AS VARCHAR(100))