How can I copy a table?

[kbrick]

How can I copy a table within PHP code? I want to copy one table--exactly--before I empty the results of the former.

Any help is appreciated! Thank you!

[Drakla]

First run

SHOW CREATE TABLE mytable.

Then get the result of that and run a regex to replace the value between the first set of backticks to your new table name, then run that create as a query, then do

INSERT INTO newtable SELECT * FROM mytable;

And you're done.

[kbrick]

OK, I'm new and not sure I understand. The table is already created, so I'm not sure I understand what the SHOW CREATE TABLE does...??? And what is a regex? All I tried so far with this is the following, and the records weren't inserted.

"INSERT INTO order_items SELECT * FROM store_shoppertrack";

I want to copy the contents of store_shoppertrack into order_items which has the identical structure.

Can you help me a little more? Thanks.

[kbrick]

OK....I played around and got it with the following:

$sql = "INSERT INTO order_items SELECT * FROM store_shoppertrack";
$add_items = mysql_query($sql) or die(mysql_error());

Thanks (once again) for your help, and Happy Easter!!!