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
5. Adding incorrect data
Foreign keys
Multicolumn foreign keys
Updates and deletes
Revision

Instruction

Good. The insertion succeeded. The data was correct. Nothing extraordinary, right? Now, let's try to add a project with a manager_id which will be incorrect.

Exercise

Add another project to the table project. Its id is 5, name 'Disco in the office', description 'A project to build a disco club inside the office so that our employees can stay longer at work on Fridays.'. The manager_id this time will be... 10. We don't have a person with id 10, so let's see what happens.

Stuck? Here's a hint!

Type

INSERT INTO project 
VALUES (5, 'Disco in the office', 'A project to build a disco club inside the office so that our employees can stay longer at work on Fridays.', 10);