SQL 查询: UPDATE QiQiBoy_Topic_Disp SET Reads = Reads +1 WHERE ParentID =0 AND TopicID =9 MySQL 返回: #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 'Reads=Reads+1 where ParentID=0 and TopicID=9' at line 1
找到原因了,Reads是保留字符串,mysql的毛病还真多
不是MYSQL的毛病多 ,是你没有按照 MYSQL的标准来写 这样写就永远不会 出错 UPDATE `QiQiBoy_Topic_Disp` SET `Reads` = `Reads` + 1 WHERE `ParentID` = 0 AND `TopicID` = 9
这样写就永远不会 出错 UPDATE `QiQiBoy_Topic_Disp` SET `Reads` = `Reads` + 1 WHERE `ParentID` = 0 AND `TopicID` = 9