I got an error code 1136 after executing the next query, even though I followed the required steps mentioned in the assignment

Hi Asmaa! You should use parentheses for each record you insert in the table. You used only one pair of parentheses, so Workbench treats this as one record and it searches for 8 columns because you have 8 records separated by comma in this one pair of parentheses. Since, you provide only two columns, error 1136 occurs. Please, use the following code: insert into dept_manager_dup ( emp_no, from_date ) values (999904, '2017-01-01'), (999905, '2017-01-01'), (999906, '2017-01-01'), (999907, '2017-01-01'); Hope this helps. Best, Tsvetelin

Follow this topic

Asmaa Abdulhamid

Last answered:

16 Dec 2021

Posted on:

26 Nov 2021

Why do I keep getting error code: 1136???

in SQL / Introduction to JOINs

1 answers ( 0 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

16 Dec 2021

Why do I keep getting error code: 1136???

Submit an answer

related questions