BadSqlGrammarException You have an error in your SQL syntax

最新推荐文章于 2025-07-07 14:37:50 发布

原创最新推荐文章于 2025-07-07 14:37:50 发布 · 382 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#BadSqlGrammarException You have an

SQL 专栏收录该内容

1 篇文章

订阅专栏

博客指出org.springframework.jdbc.BadSqlGrammarException错误，具体为MySQLSyntaxErrorException，错误出现在SQL语句‘SELECT * FROM infolimit?,?’。原因可能是SQL语句有误或字段名与SQL关键字相同，此次是后者，更改字段名可解决，还提醒name、table等常被用作字段名的其实是关键字。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: ### Error querying 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 ‘0,10’ at line 2 ### The error may exist in com/an/Dao/InfoDao.java (best guess) ### The error may involve com.an.Dao.InfoDao.selectByPage-Inline ### The error occurred while setting parameters ### SQL: SELECT * FROM infolimit ?,? ### 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 ‘0,10’ at line 2 ; bad SQL grammar []; nested exception is 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 ‘0,10’ at line 2 org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:982) org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861) javax.servlet.http.HttpServlet.service(HttpServlet.java:634) org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
原因有可能是sql语句有错或者是数据库表中的字段名与SQL中的关键字相同，这里的错是使用了和关键字同名的字段名

更改字段名就可
name，table，host，desc，table，order这些经常会被当做字段名的其实都是SQL中的关键字
别用！！！！！！！！