13.2.5.1 INSERT ... SELECT Syntax - MySQL

SELECT , you can quickly insert many rows into a table from one or many tables. ... of the INSERT statement may appear in the FROM clause of the SELECT part ...

dev.mysql.com