作者iversonjimmy (Effort)
看板Database
标题[问题] insert语法一直出现问题
时间Tue Jul 17 10:01:11 2012
dao.query("insert into SubscribeNodeHeartbeat (hostname, subscriber_no,\
interval, event_callback) select '%s', subscriber_no, '%s', '%s' from \
Subscribers where subscriber_name = '%s' AND ipv4 = '%s' AND port = '%s';" \
%(hostname, interval, event_callback, subscriber_name, ipv4, port))
我已经被这一行看似普通，却一直insert不进去的窘境困扰很久。
他一直回我说syntax error，但我真的看不出来...
内容如下
(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
'interval, event_callback) values ('TP1AA0101', 1, 3, '/Event')' at line 1")
想请问各位，我哪个有写错了？
拜托了。
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 60.250.129.63