INSERT INTO statement giving error
After running the INSERT INTO statement i get the error Error Code: 1136. Column count doesnt match value count at row 1
1 answers ( 0 marked as helpful)
Hi Sebastian!
Thanks for reaching out.
You should have the same number of columns and values in the insert statement. Some columns have default value. So, you can miss their value and they will still have this default value. Otherwise, the number of columns should be equal to the number of values. This error usually occurs when a comma is missing between two columns. Thus, Workbench treats it as one.
Hope this helps.
Best,
Tsvetelin