Introduction
Foreign keys
Multicolumn foreign keys
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);

Code editor

TableConsole