INSERT SELECT inserts the results of a SELECT into a table. See Chapter 19 for more information.
• Input
INSERT INTO tablename [(columns, ...)] SELECT columns, ... FROM tablename, ... [WHERE ...];