Last answered:

24 Jan 2021

Posted on:

19 Jan 2021


Dept_Manager_Dup table

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,
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!
1 answers ( 0 marked as helpful)
Posted on:

24 Jan 2021


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:
Then, read the provided information and execute all queries from here:
Finally, execute all queries from this item of the course contents:
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.


Submit an answer