Last answered:

01 Feb 2023

Posted on:

02 Nov 2021

1

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.

Francois

3 answers ( 0 marked as helpful)
Instructor
Posted on:

15 Dec 2021

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

Posted on:

11 Nov 2022

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

Posted on:

01 Feb 2023

0

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

Submit an answer