copy contents from one table to another

[parkerproject]

I need some help on how to copy contents from one table to another within the same mysql database.
i want this to run within an activation file.

thanks

[Mittineague]

AFAIK, if you want to "clone" a table you can use 2 queries, first to replicate the structure and then to populate it. eg.
CREATE TABLE new LIKE old
INSERT new SELECT * FROM old