Cheat Sheet logoCheat Sheet Today
SQL DDL and DML/Insert multiple rows

Add several rows in one statement.

Back to sheetBrowse commands
Sign in to save
Section: INSERT, UPDATE, and DELETE

Insert multiple rows

sql
sql
INSERT INTO roles (role_id, role_name)
VALUES
  (1, 'admin'),
  (2, 'editor'),
  (3, 'viewer');
Explanation

Multi-row INSERT is concise and often more efficient than repeated single-row inserts.

View in sheet →

Learn the surrounding workflow

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

Compare commandsView fixes

Related commands

Same sheet · prioritizing INSERT, UPDATE, and DELETE
Insert one row
Add a single row to a table.
OpenIn sheetsqlsame section
Insert from select
Populate a table using query results.
OpenIn sheetsqlsame section
Update matching rows
Modify existing data using a WHERE clause.
OpenIn sheetsqlsame section
Delete matching rows
Remove rows that match a condition.
OpenIn sheetsqlsame section
Merge or upsert data
Insert new rows and update existing ones in one logical operation.
OpenIn sheetsqlsame section
Create table
Define a new table with columns and constraints.
OpenIn sheetsql