Remove the entire column prod_id from the movie table: First, drop the foreign key constraint from the
Fantastic news! We've Found the answer you've been seeking!
Question:
Remove the entire column prod_id from the movie table:
First, drop the foreign key constraint from the movie table.
You can use the command SHOW CREATE TABLE movie; to see the name of the foreign key constraint you need to drop.
Next, drop the column prod_id from the movie table
2.List the movie titles and the names of their production companies. Only include production companies that have movies. Sort alphabetically by the movie title.
Related Book For
Posted Date: