在mysql写入数据时出现错误提示1136:Column count doesn't match value count at row 1,发现是由于写的SQL语句里列的数目和后面的值的数目不一致,原来删除一个列之后忘记了把插入的值也删除导致出现1136:Column count doesn't match value count at row 1这个问题
比如insert into 表名 (field1,field2,) values('a','b',‘c’)这样前面的是二列,后面却只有三个值,于是出现了mysql错误1136:Column count doesn't match value count at row 1。
收藏1136:Column count doesn't match value count at row 1到百度搜藏

(142)
(131)
(258)
(230)
(70)
(24)
(6)
(159)
(42)
(24)
(22)
(6)
(2)
(3)
(15)
(11)
(3)