13.2.5.1 INSERT ... SELECT Syntax - MySQL

SELECT , you can quickly insert many rows into a table from one or many tables. For example: INSERT INTO tbl_temp2 ...

dev.mysql.com