Inserting data

Write the query to add a new record with INSERT.

With INSERT we add a new record to the table. Columns and values go in parentheses, separated by commas.

INSERT INTO notes (id, title, body)
VALUES (3, 'Market', 'Süt, ekmek');

This adds one row to the notes table.

The values given with VALUES are inserted into notes as new rows.

Inserting data — details

Create is the C in CRUD. After INSERT INTO comes the table name, columns in parentheses, then VALUES and the values. Text values go in single quotes.

Insert into notes the row id=3, title='Market', body='Milk, bread'.

Show example solution

INSERT INTO notes (id, title, body)
VALUES (3, 'Market', 'Süt, ekmek')

Insert value

INSERT INTO notes (id, title)
____ (4, 'Görev');

Show answer

INSERT INTO notes (id, title)
VALUES (4, 'Görev');