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