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

Creating Tables in SQL

Introduction
Foreign keys
Multicolumn foreign keys
Updates and deletes
21. Database behavior with CASCADE - Updating rows
Revision

Instruction

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

Exercise

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!

Type

UPDATE employee SET id = 20 WHERE id = 2;