Jump to content

ERRORColumn count doesn't match value count at row


Recommended Posts

As for the INSERT query, keep in mind it needs for both columns and values the same amount of fields.

INSERT INTO table (column1,column2,column3) VALUES ('value1','value2','value3')
You may have forgotton to specify the columns, when you did not had a value for all the collumns. There are four rules for the INSERT query:-Values must be in the same order as the column names.-A partly column list is allowed-A columnlist is not prohibited-The columnlist and the values list must be in the same length
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...