You may need to copy data from one table into another. You can insert data from one table into another in MySQL.You can use the INSERT INTO SELECT statement
self insert
How to insert into same table in MySQL?
Sometimes you may need to select data from a table and insert into same table in MySQL. You may need to quickly create lot of data for testing.