Insert Multiple Rows

Add several rows in one statement using a multi-value `INSERT`.

5/5 supported engines validation-green 1 example 2 scenarios

Docker-validated Not currently validation-green

Example 1

Insert three rows in one statement

One INSERT statement creates all three rows, then the follow-up query verifies the final state.

Source table data Rows loaded before the example query runs.

Setup

CREATE TABLE teams (id INT, name VARCHAR(50));

Validated query Shared across supported engines.

SQL

INSERT INTO
  teams (id, name)
VALUES
  (1, 'Alpha'),
  (2, 'Bravo'),
  (3, 'Charlie');

SELECT
  id,
  name
FROM
  teams
ORDER BY
  id;

Expected result Returned rows for the shared example.

id	name
1	Alpha
2	Bravo
3	Charlie

Each engine supports the same multi-row insert form used here.

Useful when

Where this command helps.

seeding sample data for a new table
inserting a small batch of rows from one application action

Explanation

What the command is doing.

A multi-row INSERT lets you add several rows in one statement instead of issuing separate inserts. This is common for seed data, small batch imports, and reducing round trips from an application.

Insert Multiple Rows

Insert three rows in one statement

Where this command helps.

What the command is doing.

Keep moving through nearby tasks.