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

How to Fix ERROR 3942 (HY000) in MySQL

If you are encountering this error, “ERROR 3942 (HY000): Each row of a VALUES clause must have at least one column” then the solution is fairly simple. First we must know why this error is appearing? We must be using empty ROW() with VALUES statement.


In order to fix this, we must pass at least one value inside “ROW()” function.


We can include more than one parameters or values in “ROW()” method or we can also use more than one “ROW()” functions.

VALUES ROW(1, 'Jet', 'Black'), ROW(2, 'Faye', 'Valentine');

But the main point is that “ROW()” function must have at least one value. If you have any question, please write in comments section.