Dept_Manager_Dup table

Question

Hi, I'm on the Inner Joins lecture and I don't have the dept_manager_dup table in SQL. Where was it added? I can't seem to locate it. I created it myself and tried to add into data from the dept_manager table using this: INSERT INTO dept_manager_dup ( dept_no,
emp_no,
from_date,
to_date )SELECT * FROM dept_manager; I got an error code that said 1406: Data too long for column 'dept_no' at row 1 I'm so confused!

Answer 1

Hi Zoe!
Thanks for reaching out.
Please accept my apologies for the delayed response.

Please execute the code (i.e., all queries written in bold) provided at the bottom part of the following lecture from the course: https://learn.365datascience.com/courses/sql/introduction-to-joins
Then, read the provided information and execute all queries from here: https://learn.365datascience.com/courses/sql/introduction-to-joins
Finally, execute all queries from this item of the course contents: https://learn.365datascience.com/courses/sql/introduction-to-joins
After doing this, you will have understood our idea and be informed and set up the database so that you can smoothly proceed with working with joins.
Hope this helps
but please feel free to get back to us should you need further assistance.

Thank you.

Best,
Martin

Dept_Manager_Dup table

Submit an answer