Bug2:You have an error in your SQL syntax; 500错误 sql错误

最新推荐文章于 2022-07-28 18:46:29 发布

m13681475071

最新推荐文章于 2022-07-28 18:46:29 发布

阅读量252

点赞数

文章标签： Bug整理

本文链接：https://blog.csdn.net/m13681475071/article/details/78984927

版权

具体例子如下图但记住一点他报sql错误就一定真的只是sql错误就找sql就好即便你怎么看sql也没错那也依然只是你没看到,绝对不会是其他地方如链接参数传递时出错,像这次这个逗号.......我居然找了2个小时,就....很亏

具体错误代码

Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'CREATED_DATE=now(),SUMMARY='321',
         cover='/upload/blog/1515154888999.jpg' at line 1
### The error may involve com.ssm.blog.dao.BlogDAO.updateBlog-Inline
### The error occurred while setting parameters
### SQL: update blog set title=?,,CREATED_DATE=now(),SUMMARY=?,          cover=?,content=?,CATEGORY_ID=? where ID=?

具体错误图