Translating SQLException with SQL state '42000', error code '1064', message [You have an error in yo

最新推荐文章于 2024-07-27 14:50:38 发布

往前的

最新推荐文章于 2024-07-27 14:50:38 发布

阅读量1.2w

点赞数

分类专栏： mybatis 文章标签： mysql 42000 1064

本文链接：https://blog.csdn.net/m0_37355951/article/details/73381214

版权

mybatis 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

概述：

尴尬自动生成代码都有错误，很郁闷，最后发现用了mysql的保留字 desc

[org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator] - Translating SQLException with SQL state '42000', error code '1064', message [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 'desc ) 
     values ( '00aaaaaaaaaaaaaa',
      
      
        '26208',
      
' at line 11]; SQL was [] for task [
### 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 'desc ) 
     values ( '00aaaaaaaaaaaaaa',
      
      
        '26208',
      
' at line 11
### The error may involve com.rinlink.intelligent.DAO.LockStatusDAO.insertSelective-Inline
### The error occurred while setting parameters
### SQL: insert into lock_status      ( device_id,                       serial_num,                       status,                       desc )       values ( ?,                       ?,                       ?,                       ? )
### 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 'desc ) 
     values ( '00aaaaaaaaaaaaaa',
      
      
        '26208',
      
' at line 11
]
[com.rinlink.intelligent.socket.parser.ParserDispatch] - 解析过程失败

mysql保留字参考如下：

http://luanxiyuan.iteye.com/blog/2224331