How to Fix ERROR 1136 21S01 Column count doesnt match value count at row 1 when Inserting Data in MySQL 3

How to Fix ERROR 1136 (21S01): Column Count Doesn’t Match Value Count at Row 2

If you are getting this error “ERROR 1136 (21S01): Column count doesn’t match value count at row 2” then this means that you are using “ROW()” function multiple times but values or parameters does not match in count. You must be doing something like this.

VALUES ROW(1, 2), ROW(3);

In order to fix that we need to put the same number of values inside “ROW()” function.

VALUES ROW(1, 2), ROW(3, 4);

This error also may appear in case of incorrect “INSERT” query. When must insert correct number of rows while inserting data into the columns. We can make that sure by naming columns while inserting data. This type of query may cause an error.

INSERT INTO table_name VALUES (value1, value2, value3, ...);

This is the correct way to insert data in a table.

INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)
VALUES ('Cardinal', 'Tom B. Erichsen', 'Skagen 21', 'Stavanger', '4006', 'Norway');

I hope this will help you to fix this error. If you have any questions, please write in comments section.