admin管理员组文章数量:1026214
使用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("`字段名`")
问题解决.
记录每一次踩坑,如有不足希望指出.
使用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字段名为关键字,怎么办? 内容由热心网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://it.en369.cn/jiaocheng/1740119729a1715423.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。
发表评论