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 theid
column'Justin Bieber'
is text that will be inserted into thename
column22
is an integer that will be inserted into theage
column
Instructions
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?
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?