Insert Multiple Rows With One SELECT Statement

Use INSERT…SELECT.

INSERT INTO table_name
SELECT col1, col2, col3 FROM table_name_same_or_other

The multiple rows are returned based on the conditions after your SELECT statement.

You can use this to copy contents from 1 table to another for backup or simply for moving or storing data.