SQL · Writing data

insert from select

Copies rows from another query into a table.

sqlRunnable example sql course

Syntax

insert into t (cols) select …

Example

Open in the lab

CREATE TEMP TABLE source (body TEXT);
INSERT INTO source VALUES ('a'), ('b');
CREATE TEMP TABLE copy (body TEXT);
INSERT INTO copy (body) SELECT body FROM source;
SELECT * FROM copy;

Learn this in the course

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.

Open the course

insert from select

Example

More in this group

Learn this in the course