If you are copying between two tables in the same database, you can do something like
INSERT INTO table2
(column_name(s))
SELECT column_name(s)
FROM table1;
Example:
INSERT INTO table2
SELECT * FROM table1;
Check this tutorial-
SQL INSERT INTO SELECT Statement[
^]
Hope, it helps :)