Introduction
Primary keys
Foreign keys
Updating and deleting with foreign keys
Instruction
Superb! As you could see, the project led by Amelia Foster, whose id = 1, was deleted too.
So now we know how CASCADE works. How about other options? Let's find out!
Exercise
Experiment again! Using the template code we provided, choose the type of foreign key you want by deleting the double hyphen (--) from the line of the option you want to try. You can use the update/delete we provided in the Hint or make up your own.
Remember: Each time you click , your code starts fresh. The changes you made in one call are not preserved in the next call.
Stuck? Here's a hint!
Example update:
UPDATE employee SET id = 15 WHERE id = 1;
Example delete:
DELETE FROM employee WHERE id = 1;
