MySQL SQL

MySQL INSERT SELECT

Insert the result of a query into another table.

INSERT INTO archived_products (name, price)
SELECT name, price FROM products
WHERE discontinued = 1;

The selected columns must match the destination columns in number and compatible type.