how to duplicate a mysql table along with data using phymyadmin

how to duplicate a mysql table along with data usin开发者_JAVA技巧g phymyadmin

To copy a table, you can just execute the following SQL:

CREATE TABLE copyname SELECT * FROM originalname

PHPMyAdmin also has built-in functionality to export table data to a flat file.

Construct a create table script, export it to .sql file, change the table name, and reimport it back.

Or better, take the original table schema, construct a create table script, and run the script in phpmyadmin, that should do.