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

1 Expert Approved Answer
Step: 1 Unlock

Answer The error is occurring because the number of columns in the INSERT ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!