Data Migration with INSERT ... SELECT

This technique migrates data between tables or databases with transformation.

INSERT INTO new_table (id, name)
SELECT id, name FROM old_table;