Inner Join- creating the department_dup table

Question

How do I set up departments_dup and how use CHANGE COLUMN to change the ‘dept_no’ and ‘dept_name’ columns to NULL. Is that the same table departments_dup that I use the change command?

Answer 1

Hi Maxime!

Thanks for reaching out.

I think you are referring to the following two queries.

ALTER TABLE departments_dup
CHANGE COLUMN dept_name dept_name VARCHAR(40) NULL;

ALTER TABLE departments_dup
CHANGE COLUMN dept_no dept_no CHAR(4) NULL;

Hope this helps but please feel free to get back to us should you need further assistance. Thank you.

Kind regards,
Martin

Inner Join- creating the department_dup table

Submit an answer

related questions