bad SQL grammar []； nested exception is java.sql.SQLSyntaxErrorException: You have an error in your

报错信息：bad SQL grammar []; nested exception is 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

奥义喷火恐龙

5935人浏览 · 2021-08-15 19:33:38

奥义喷火恐龙 · 2021-08-15 19:33:38 发布

报错信息：

bad SQL grammar []; nested exception is 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 '22
      
      
        '',
      
      
        '2021-08-15' )' at line 39]

问题：
在这里插入图片描述
修改xml文件时，忘记添加逗号，mybatis只会默认处理sql语句结尾的逗号。