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

Good. We now know that we can't add a row with a foreign key value that's not in the other table.

Now, what happens if we change the data in the main table while there are some foreign keys involved?

Exercise

In the employee table, change the employee id = 1 to id = 107.

Stuck? Here's a hint!

Here's the syntax:

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