Can you show the instructions to reproduce dept_manager_dup table?

Question

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.

Francois

Answer 1

Hi Francois!

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.
Best,
Tsvetelin

Answer 2

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

Answer 3

The dept_manager_dup creation is in the previous "Excerise" Section. You need to scroll the on-screen text to see "Task 2"

Can you show the instructions to reproduce dept_manager_dup table?

Submit an answer

related questions