Database new error code: 1136 Column count doesn ' t match value count at row 1__ database

Today in the test, a few new test data, but has been the SQL error, is clearly the previous rules, and add such a simple SQL

Error: 1136 Column count doesn ' t match value count at row 1

The Internet to check the information that this error is "inserted data and table column number does not match",

My SQL statement is in addition to the ID all inserted,

INSERT into Test VALUES (1,1,1,1,1,1,1,2); Table has 9 fields, I use the MySQL database, the ID field set the default growth

Before inserting this is OK, he said I am not the right number, I will add the ID, into:

INSERT into Test VALUES (9,1,1,1,1,1,1,1,2);

This is still an error.

No way, or do not have to insert the whole item, I changed into a

INSERT into (a,b,c,d,e,f,g,h,i) test VALUES (1,1,1,1,1,1,1,2);

It finally worked.

No longer lazy, even if the test must be serious to do.