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?

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

Follow this topic

Maxime Darbouze

Last answered:

18 Jun 2022

Posted on:

20 Apr 2022

Inner Join- creating the department_dup table

in SQL / Introduction to JOINs

1 answers ( 0 marked as helpful)

Martin Ganchev

Instructor

Posted on:

18 Jun 2022

Inner Join- creating the department_dup table

Submit an answer

related questions