admin管理员组

文章数量:1530873

使用Mybatis-Plus查询的时候出现错误

报错信息

org.springframework.jdbc.BadSqlGrammarException: 
### Error querying 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 'key,updated_at,desc FROM wycms_category WHERE id=1' at line 1
### The error may exist in com/wycms/category/dao/CategoryDao.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT id,template,image,content_template,module,title,content,created_at,path,hide,pagesize,`name`,alias,seq,key,updated_at,desc FROM wycms_category WHERE id=?
### 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 'key,updated_at,desc FROM wycms_category WHERE id=1' at line 1
; 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 'key,updated_at,desc FROM wycms_category WHERE id=1' at line 1

可以看到有两个字段key,desc和sql语句关键字冲突,

解决思路:

在mysql中我们可以通过添加单引号解决

SELECT id,template,image,content_template,module,title,content,created_at,path,hide,pagesize,`name`,alias,seq,'key',updated_at,'desc' FROM wycms_category WHERE id=1

这样就解决了.

在mybatis-plus中我们可以通过向实体表中添加注解的方式:

@TableField("`字段名`")

问题解决.

记录每一次踩坑,如有不足希望指出.

本文标签： 字段关键字mysql

版权声明：本文标题：MySql字段名为关键字,怎么办? 内容由热心网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：https://m.elefans.com/xitong/1724977292a1000535.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。