Skip to Content
Codecademy Logo
Learn SQL
Learn
Manipulation
Insert

The INSERT statement inserts a new row into a table. You can use the INSERT statement when you want to add new records. The statement below enters a record for Justin Bieber into the celebs table.

INSERT INTO celebs (id, name, age) 
VALUES (1, 'Justin Bieber', 22);

1. INSERT INTO is a clause that adds the specified row or rows.
2. celebs is the name of the table the row is added to.
3. (id, name, age) is a parameter identifying the columns that data will be inserted into.
4. VALUES is a clause that indicates the data being inserted.
(1, 'Justin Bieber', 22) is a parameter identifying the values being inserted.

  • 1 is an integer that will be inserted into the id column
  • 'Justin Bieber' is text that will be inserted into the name column
  • 22 is an integer that will be inserted into the age column

Instructions

1.

Add a row to the table. In the code editor, type: 

INSERT INTO celebs (id, name, age) 
VALUES (1, 'Justin Bieber', 22);

Look at the Database Schema. How many rows are in the celebs table?

2.

Add three more celebrities to the table. Beneath your previous INSERT statement type: 

INSERT INTO celebs (id, name, age) 
VALUES (2, 'Beyonce Knowles', 33); 

INSERT INTO celebs (id, name, age) 
VALUES (3, 'Jeremy Lin', 26); 

INSERT INTO celebs (id, name, age) 
VALUES (4, 'Taylor Swift', 26);

Look at the Database Schema. How many rows are in the celebs table now?

Folder Icon

Take this course for free

Already have an account?