On January 21th at 14:15 UTC , progression through exercises will be unavailable for 10 minutes due to a planned maintenance break.
Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Foreign keys
Multicolumn foreign keys
Updates and deletes
21. Database behavior with CASCADE - Updating rows


Okay, we've got the CASCADE option set, now let's see how it works!


Let's see what happens in the table project when we update an id in the table employee. Take the employee with id 2 and change the id to 20.

Stuck? Here's a hint!


UPDATE employee SET id = 20 WHERE id = 2;