Can you show the instructions to reproduce dept_manager_dup table?
In this lesson, we refere to a duplicate of dept_manager_table name dept_manager_dup.
It includes null values and some new inserted values compared to the original dept_manager table.
Not sure if this was part of a previous exercise, but I don't recall having to create and modify the dept_manager_dup table.
Can you show the instructions to re-create this duplicate table with the null values and new content if any?
Thanks for reaching out.
The duplicate table should be the same. So, the code for inserting records in the duplicate table is:
INSERT INTO departments_dup ( dept_no, dept_name ) SELECT * FROM departments;
Hope this helps.
This is for the wrong table. He's referred to the dept_manager table not the departments table. In Section 8, the code loaded in for the dept_manager table involves Not Null constraints for all fields