INSERT with SELECT

Copy data from another table.

INSERT ... SELECT

With INSERT INTO ... SELECT you copy data chosen from one table into another.

INSERT INTO archive (id, name)
SELECT id, name FROM products
WHERE stock = 0;

This query copies out-of-stock products to the archive.

The result of a SELECT query is inserted into archive as new rows. WHERE keeps only the rows where stock = 0 holds.

SELECT replaces VALUES. The SELECT column count must match the INSERT columns. Ideal for bulk moves.

Copy all rows from products into the archive table.

Show example solution

INSERT INTO archive (id, name)
SELECT id, name FROM products

Select and insert

INSERT INTO archive (id, name)
____ id, name FROM products;

Show answer

INSERT INTO archive (id, name)
SELECT id, name FROM products;