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 解决办法
添加查询语句字段,并且要和临时表里字段个数一致
2024-03-01 10:56:22
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 解决办法
添加查询语句字段,并且要和临时表里字段个数一致