faqts : Communication : Telephone : Errors

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

33 of 43 people (77%) answered Yes
Recently 4 of 10 people (40%) answered Yes

Entry

What does the error 'Column count doesn't match value count' mean?

Feb 2nd, 2000 14:34
Nathan Wallace, Sterling Hughes


Your insert statement is incorrect, you are putting a different amount
of values in than there are columns (I am guessing less values than
columns.  Try explicitly stating what columns you are updating, ie:

    INSERT INTO tblname (col1,col2) VALUES ('col1val','col2val');