Order report

Insert, update and delete rows on the order table.

Challenge 2: Insert data

In this challenge you will write an INSERT that adds two rows to a table. Use multi-row insert.

INSERT INTO products (id, name, price) VALUES (1, 'A', 5), (2, 'B', 10);

This query adds two rows in one query.

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

Insert id=1 name='Pen' price=5 and id=2 name='Book' price=12 into products in one query.

Show example solution

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

Next lesson: Data update