MySQL Forums
Forum List  »  Newbie

Re: Error Code: 1136. "Column count doesn't match value count" problem.
Posted by: Peter Brawley
Date: November 10, 2016 07:48PM

The error message means exactly what it says.

As the manual page for Insert says, when using Insert Into ... (...) values(...) syntax, you need to either provide Null as a value for the auto_increment column, or provide a column name list which omits the auto_increment column.

If that does not lead you to the solution, let's see the result of Show Create Table for the table, and actual Insert statements that are eliciting the error.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.