【异常】MybatisPlus批量插入MySQL数据库后，提示租户异常BatchUpdateException: Unknown column ‘tenant_id‘ in ‘field list‘

本本本添哥

已于 2025-06-30 18:35:11 修改

阅读量403

点赞数 10

CC 4.0 BY-SA版权

分类专栏： 003 - 数据库文章标签：数据库 mysql

于 2025-05-20 11:21:56 首次发布

本文链接：https://blog.csdn.net/wstever/article/details/148083857

003 - 数据库专栏收录该内容

372 篇文章 ¥19.90 ¥99.00

订阅专栏

超级会员免费看

一、报错内容

### Error flushing statements.  
Cause: org.apache.ibatis.executor.BatchExecutorException: com. xxxx.xxxx.web.mapper.OmoStyleHomePageAdMapper.insert (batch index #1) failed. Cause: java.sql.BatchUpdateException: Unknown column 'tenant_id' in 'field list'

### Cause: org.apache.ibatis.executor.BatchExecutorException: com.xxxx.xxxx.web.mapper.OmoStyleHomePageAdMapper.insert (batch index #1) failed. 

Cause: java.sql.BatchUpdateException: Unknown column 'tenant_id'