MyBatis-Plus 学习日常避坑小计

最新推荐文章于 2023-11-04 19:08:19 发布

浪子燕清Andy

最新推荐文章于 2023-11-04 19:08:19 发布

阅读量324

点赞数

CC 4.0 BY-SA版权

文章标签：数据仓库

本文链接：https://blog.youkuaiyun.com/qq_37044622/article/details/124444189

在使用MyBatis-Plus（MP）进行逻辑删除操作时，需要注意不要使用数据库的关键字，如`delete`。本文通过一个示例展示了由于使用`delete`作为逻辑删除字段导致的SQL语法错误。当尝试执行查询时，遇到了`BadSqlGrammarException`，提示SQL语句语法错误。解决方案是选择一个非关键字作为逻辑删除字段，以确保查询的正确性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

MyBatis-Plus 逻辑删除

话不多说，直入主题，在使用 MP的的时候切记不要使用数据库的一些关键字，我的数据库是MYSQL，当然别的数据库暂时还没遇到，

@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
    @TableId(type = IdType.AUTO)
    private Long id;
    private String name;
    private int age;
    private String email;
    @TableField(fill = FieldFill.INSERT)
    private Date create_time;
    @TableField(fill = FieldFill.INSERT_UPDATE)
    private Date update_time;
    @Version//乐观锁注解
    private Integer version;
    @TableLogic //逻辑删除 这里不能使用 delete关键字，不然会报SQl 语句错误
    private Integer delete;
}

报错

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 'delete  FROM user 
 WHERE delete=0) TOTAL' at line 1
### The error may exist in com/andy/mybatisplus/mapper/UserMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT COUNT(*) FROM (SELECT  id,name,age,email,create_time,update_time,version,delete  FROM user   WHERE delete=0) TOTAL
### 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 'delete  FROM user 
 WHERE delete=0) TOTAL' 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 'delete  FROM user 
 WHERE delete=0) TOTAL' at line 1