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

The Basics of Creating Tables in SQL

Introduction
4. Adding incorrect data
Foreign keys
Multi-column Foreign Keys
Summary

Instruction

Good. The data was successfully inserted. Nothing out of the ordinary, 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 is 'Disco in the office', and description is: 

'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);