在执行一条删除命令时,遇到数据QUERY错误,出现mysql #1064 error 错误,提示如下
SQL 查询:
DELETE FORM `hwg_news` WHERE `hwg_news`.`ID` =3 LIMIT 1
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 'WHERE `hwg_news`.`ID`=3 LIMIT 1' at line 1
上面这个mysql #1064 error,#1064 错误暂时的解决办法是
DELETE FORM `hwg_news` WHERE `hwg_news`.`ID` IN(3)
这样做,将导致删除效率低下,上网暂时没有找到解决办法,估计可能是mysql版本的问题