### 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 'numeric,unit,generic,searching,segments,create_time,update_time FROM tb_spec_pa' at line 1
### The error may exist in com/leyou/item/mapper/SpecParamMapper.java (best guess)
### The error may involve com.leyou.item.mapper.SpecParamMapper.select-Inline
### The error occurred while setting parameters
### SQL: SELECT id,cid,group_id,name,numeric,unit,generic,searching,segments,create_time,update_time FROM tb_spec_param WHERE group_id = ?
### 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 'numeric,unit,generic,searching,segments,create_time,update_time FROM tb_spec_pa' at line 1
; 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 'numeric,unit,generic,searching,segments,create_time,update_time FROM tb_spec_pa' at line 1
原因是sql语句/sql表中:
存在关键字:name numeric
这时候有两种处理办法:
方法一:通过mapper中的@Column注解,来声明这个字段对应的列名:
方案二:
通过通用mapper的统一配置,全局修改关键词冲突问题
mapper:
wrap-keyword: "`{0}`"