[Err] 1136 - Column count doesn't match value count at row 1

1 错误描述

[Err] 1136 - Column count doesn't match value count at row 1

Procedure execution failed
1136 - Column count doesn't match value count at row 1

2 错误原因

在存储过程里,创建临时表,插入数据时插入的字段个数跟临时表里的字段个数不一致,导致出错

3 解决办法

添加查询语句字段,并且要和临时表里字段个数一致

上一篇:vue 自定义分页组件


下一篇:[Mybatis - 1A] - Cause: java.sql.SQLException: Column count doesn't match value count at row 1