After running the INSERT INTO statement i get the error Error Code: 1136. Column count doesnt match value count at row 1

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

Follow this topic

Sebastian Tau

Last answered:

18 Nov 2022

Posted on:

18 Nov 2022

INSERT INTO statement giving error

in SQL / The INSERT statement - Part I

1 answers ( 0 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

18 Nov 2022

INSERT INTO statement giving error

Submit an answer

related questions