qq_精慕门0012359
2022-06-02 14:07
### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'deleted' in 'where clause'
### The error may exist in com/mp/dao/UserMapper.java (best guess)
### The error may involve com.mp.dao.UserMapper.deleteById-Inline
### The error occurred while setting parameters
### SQL: UPDATE user SET deleted=1 WHERE id=? AND deleted=0
这个错误是指你的user表中没有deleted这一列,你需要修改表结构,在sql中执行
ALTER TABLE user ADD deleted INT;
MyBatis-Plus进阶
23265 学习 · 118 问题
相似问题