This lesson's interactive features are locked, please to keep using them

Insert Statement

Tables are pretty useless without data in them! In SQL we can add records to a table using an INSERT INTO statement. When using an INSERT statement we must first specify the table we are inserting the record into, followed by the fields within that table we want to add VALUES to.

Example INSERT INTO statement:

INSERT INTO employees(id, name, title)
VALUES (1, 'Allan', 'Engineer');

Assignment

Let's start manually adding some of the records to our users table!

Take a look at the CREATE TABLE statement in the setup code in the up.sql tab for the users table structure, and use that information to insert the following records into the table:

Record 1

id: 1
name: 'David'
age: 34
country_code: 'US'
username: 'DavidDev'
password: 'insertPractice'
is_admin: false

Record 2

id: 2
name: 'Samantha'
age: 29
country_code: 'BR'
username: 'Sammy93'
password: 'addingRecords!'
is_admin: false