Cheat Sheet logoCheat Sheet Today
SQL DDL and DML/Insert from select

Populate a table using query results.

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

Insert from select

sql
sql
INSERT INTO active_customers (customer_id, email)
SELECT customer_id, email
FROM customers
WHERE status = "active";
Explanation

Great for staging and snapshot tables.

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 multiple rows
Add several rows in one statement.
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