Mysql----error:no query specified
mysql下抛出错误：
error:no query specified
出现此错误是sql不合法原因：
如：select * from abc\G;
或者
select * from abc;;
\G后面不需要再加分号;
mysql> select * from giftcdkey where actID=2012322\G;
*************************** 1. row ***************************
id: 2026192
ver: 1
createtime: 2015-10-23 14:54:39
updatetime: 2015-10-23 14:54:39
cdkey: 4QRNTQ
giftpackID: 2014612
actID: 2012322
1 row in set (0.13 sec)
ERROR:
No query specified
mysql> select * from giftcdkey where actID=2012322\G
*************************** 1. row ***************************
id: 2026192
ver: 1
createtime: 2015-10-23 14:54:39
updatetime: 2015-10-23 14:54:39
cdkey: 4QRNTQ
giftpackID: 2014612
actID: 2012322
1 row in set (0.11 sec)
mysql 1292-Truncated incorrect double value 错误
UPDATE `ts_personinfo_epproperty` SET `k04`='博士研究生' AND `k51`='1' where id<50
and报错
UPDATE `ts_personinfo_epproperty` SET `k04`='博士研究生', `k51`='1' where id<50
搞定