INSERT SELECT

INSERT SELECT inserts the results of a SELECT into a table. See Lesson 15, "Inserting Data," for more information.

INSERT INTO tablename [(columns, …)]
SELECT columns, … FROM tablename, …
[WHERE …];