Inner Join- creating the department_dup table
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?
1 answers ( 0 marked as helpful)
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