INSERT basics

Add a new row with INSERT INTO.

With INSERT INTO you add a new row to a table. Columns and values go in parentheses.

INSERT INTO products (id, name, price)
VALUES (1, 'Kalem', 5);

This query adds one row to the products table.

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

INSERT basics — details

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

Insert into products the row id=1, name='Pen', price=5.

Show example solution

INSERT INTO products (id, name, price)
VALUES (1, 'Kalem', 5)

Values

INSERT INTO products (id, name)
____ (1, 'Kalem');

Show answer

INSERT INTO products (id, name)
VALUES (1, 'Kalem');