Question: Why am getting the error below ERROR 1136 (21S01): Column count doesn't match valuecount at row 1 MySQL code is below CREATE TABLE Books (
Why am getting the error below
ERROR 1136 (21S01): Column count doesn't match valuecount at row 1
MySQL code is below
CREATE TABLE Books (
Book_ID int AUTO_INCREMENT,
Book_Name varchar(20),
Book_Colour varchar(20),
PRIMARY KEY (Book_ID)
);
INSERT INTO Books VALUES (
'Lolita',
'White');
Step by Step Solution
3.52 Rating (162 Votes )
There are 3 Steps involved in it
Answer The error is occurring because the number of columns in the INSERT ... View full answer
Get step-by-step solutions from verified subject matter experts
