how to copy data of one table into another table

What kind of message are you getting?

try below sql script:
INSERT INTO table1
(col1,col2,col3)
SELECT col1,col2,col3 FROM table2
 
This should solve your problem.
 let me know if you face any issue