Mybatis-plus：bad SQL grammar []； nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErro

记录一个报错信息：
在使用Mybatis-plus时，测试查询单个数据时一直报错

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 'desc,state,created,updated  FROM tb_admin_role 
 
 WHERE id = 1' at line 1

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 'desc,state,created,updated  FROM tb_admin_role 
 
 WHERE id = 1' at line 1
### The error may exist in com/tanhua/manage/mapper/AdminRoleMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT  id,name,desc,state,created,updated  FROM tb_admin_role     WHERE 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 'desc,state,created,updated  FROM tb_admin_role 
 
 WHERE id = 1' 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 'desc,state,created,updated  FROM tb_admin_role 
 
 WHERE id = 1' at line 1 

测试类

@Test
    public void test(){
        AdminRole adminRole = adminRoleMapper.selectOne(Wrappers.<AdminRole>lambdaQuery().eq(AdminRole::getId, 1));
        System.out.println("adminRole = " + adminRole);
    }

pojo

@Data
@AllArgsConstructor
@NoArgsConstructor
public class AdminRole extends BasePojo {

    private Long id;
    private String name;
    private String desc;//角色的描述
    private Boolean state;// 角色的状态，1启用，2停用

}

MySQL字段

后来查询到是数据库字段名称有关键字，desc。导致无法映射到pojo封装回去，更改desc字段后恢复。