Databases & APIs
INSERT...SELECT in MySQL: Copying Rows Between Tables
Copying rows from one table into another as a SELECT-then-loop-INSERT operation means one query per row — INSERT...SELECT does the whole copy as a single statement, entirely inside the database.