MySQL Crash Course

INSERT SELECT

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 ...];