运行下面两行查询:
UPDATE alicallbackinfo SET out_trade_no='100220515453453463464' WHERE backinfoid=1550085
SELECT out_trade_no FROM alicallbackinfo WHERE backinfoid=1550085
错误信息:
查询:update alicallbackinfo set out_trade_no='100220515453453463464' where backinfoid=1550085 SELECT out_trade_no FROM alicallbackinf...
错误代码: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT out_trade_no FROM alicallbackinfo WHERE backinfoid=1550085' at line 3
看样子是把两句连接成了一个SQL语句来理解了,所以报语法错误。于是我试着在每句后面加了分号,成功解决了这个问题。
UPDATE alicallbackinfo SET out_trade_no='100220515453453463464' WHERE backinfoid=1550085;
SELECT out_trade_no FROM alicallbackinfo WHERE backinfoid=1550085;