org.springframework.jdbc.BadSqlGrammarException: Error updating database

wei_shuo的个人主页

wei_shuo的学习社区

Hello World ！

org.springframework.jdbc.BadSqlGrammarException: Error updating database

报错信息：

org.springframework.jdbc.BadSqlGrammarException:

Error updating database. Cause: 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 ‘deletes from mybatis.user where id=5’ at line 1

分析：

您的 SQL 语法有误

• You have an error in your SQL syntax

检查与您的MySQL服务器版本相对应的手册，了解在附近使用的正确语法 ‘deletes from mybatis.user where id=5’

check the manual that corresponds to your MySQL server version for the right syntax to use near ‘deletes from mybatis.user where id=5’ at line 1

根据标错信息得知SQL语句写错了，此时需要检查书写SQL的文件(userMapper.xml映射文件)，发现手误写错delete

结语：创作不易，如果觉得博主的文章赏心悦目，还请——点赞收藏⭐️评论冲冲冲