Duplicate Tables?

[figment]

I would like to simply copy table structures, and data into a table of another name in the same database.

I cannot use phpMyAdmin for this, is there a simple COPY TABLE function?

If not, then whats the closest thing i can do?

[Vex]

Look up the documentation for the CREATE TABLE command.

It appears (from a brief read) that you can do:-

create table bar (m int) select n from foo;

Not quite what you need, because you still have to specify all the columns and column types, but it will pull all the data into the table for you....

HTH,