Inserting Multiple Rows

INSERT INTO employees (id, first_name, last_name, email) VALUES (2, 'Jane', 'Smith', 'jane.smith@example.com'), (3, 'Emily', 'Jones', 'emily.jones@example.com');

You can insert multiple rows in a single INSERT statement by separating each set of values with a comma.

Related concepts

Inserting Multiple Rows

Inserting Multiple Rows — Structure map

Clickable & Draggable!

Inserting Multiple Rows — Related pages: