Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

SQL Constraints

Introduction
Primary keys
Foreign keys
Updating and deleting with foreign keys
Summary

Instruction

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

Exercise

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

Observe how the manager_id changes when updating the employee table.

Stuck? Here's a hint!

Syntax reminder:

UPDATE ...
SET ...
WHERE ...;