Introduction
4. Adding new data
Foreign keys
Multicolumn foreign keys
Updates and deletes
Revision

Instruction

Great! Okay, let's add a new project and see what happens.

Exercise

Add a new project to the table project. Its id is 4, name 'Office party', description 'To be completed'. The manager is Amelia Foster, so the manager_id will be 1.

Stuck? Here's a hint!

Type

INSERT INTO project 
VALUES (4, 'Office party', 'To be completed', 1);

Console

Code editor

Result

TableConsole