Add several records in one statement.

Section: Insert, update, delete, and upsert

Insert multiple rows

sql
sql
INSERT INTO tags (name) VALUES ('sql'), ('sqlite'), ('database');
Explanation

Batch inserts are concise and usually faster than one statement per row.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Related commands

Same sheet · prioritizing Insert, update, delete, and upsert
Insert one row
Add a new record.
OpenIn sheetsqlsame section
Update matching rows
Modify one or more records.
OpenIn sheetsqlsame section
Delete matching rows
Remove records by condition.
OpenIn sheetsqlsame section
Upsert with ON CONFLICT
Insert or update on a uniqueness collision.
OpenIn sheetsqlsame section
Ignore duplicates on conflict
Keep the existing row when a unique key collides.
OpenIn sheetsqlsame section
Select all columns
Read rows from a table.
OpenIn sheetsql1 tag match