Multiple rows

Insert many rows in a single INSERT.

Multi-row insert

A single INSERT can add many rows. You separate value sets with commas.

INSERT INTO products (id, name, price)
VALUES (4, 'Çanta', 25), (5, 'Cetvel', 3);

This query adds two rows in one query.

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

Multi-row insert is faster than one-by-one. Each value set goes in parentheses, separated by commas; no comma after the last set.

Insert id=4 'Bag' and id=5 'Ruler' into products in one query.

Show example solution

INSERT INTO products (id, name)
VALUES (4, 'Çanta'), (5, 'Cetvel')

Two rows

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

Show answer

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