Transferring Data from One Table to Another

This is to transfer data from one table to another within a single database

To transfer all data from one table to another within the same database:

“INSERT INTO TABLE2 SELECT * FROM TABLE1”

]]>