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.
VALUES ROW();In order to fix this, we must pass at least one value inside “ROW()” function.
VALUES ROW('Alen');
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.
