[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 解决的方法

   加入查询语句字段,而且要和暂时表里字段个数一致

posted @ 2017-07-14 17:23  llguanli  阅读(333)  评论(0编辑  收藏  举报