Summary - INSERT

Transfer data with single and multi-row INSERT.

In this group you learned INSERT basics, multi-row, INSERT SELECT and DEFAULT. Adding data is now easy.

INSERT INTO products (id, name, price)
VALUES (7, 'Kitap', 30), (8, 'Defter', 12);

This query adds two products in one query.

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

Exercise Summary - INSERT

Insert id=9, name='Pen', price=5 into products.

Show example solution

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