错误描述

java.sql.SQLSyntaxErrorException: 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 'order = 0 WHERE habit_id = '20001926'' at line 1

 

我在执行一段 sql时出现了上面的错误

sql语句为：

"UPDATE user_habit_info SET order = %s WHERE habit_id = '%s'"

原因是该语句中有 mysql里的关键字 order 所以报错了。

把order换成其他字段即可。