I'm sorta noob still at SQL, and I don't know how to edit the number of values per columns so I don't know how to fix the error
"column count doesn't match value count at row 1"
any help?![]()
I'm sorta noob still at SQL, and I don't know how to edit the number of values per columns so I don't know how to fix the error
"column count doesn't match value count at row 1"
any help?![]()
It means that you have the incorrect number of values.
For example:
would be incorrect, aswell as:Code:insert into TABLENAME (column1, column2, column3, column4) values (value1, value2, value3)
To correct this simply do like so:Code:insert into TABLENAME (column1, column2, column3) values (value1, value2, value3, value4)
Code:insert into TABLENAME (column1, column2, column3, column4,) values (value1, value2, value3, value4)