java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax； check the manual that corres
错误描述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 =
·
错误描述
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换成其他字段即可。
华为开发者空间，是为全球开发者打造的专属开发空间，汇聚了华为优质开发资源及工具，致力于让每一位开发者拥有一台云主机，基于华为根生态开发、创新。
更多推荐
0
0- 0
已为社区贡献8条内容
所有评论(0)