mysql提示Column count doesn't match value count at row 1错误

mysql提示Column count doesn't match value count at row 1错误

开发中运行mysql脚本，发现提示mysql提示Column count doesn't match value count at row 1错误，坚持后发现是由于写的SQL语句里列的数目和后面的值的数目不一致， 

比如insert into 表名 (field1,field2,field3) values('a','b')这样前面的是三列，后面却只有二个值，这就会出现这个错误的。 

 

来源 http://msq.iteye.com/blog/141634