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: .... SELECT you can copy data from one database to another.

dev.mysql.com