Copy a table (easy question)

[nca]

Is there a easy way to make a copy of a table?

[RGBlackmore]

phpmyadmin

[nnichols]

If you want to do it using a GUI tool use MySQL-Front available for download here- http://efux.de/mysqlfront/MySQL-Front_2.5_Setup.exe

If you want to do it using sql just use something like this -

CREATE TABLE new_tbl_name SELECT * FROM tbl_name

where tbl_name is the name of the table you want to copy. If you do it this way you will need to add any indexes manually.

Hope this helps 😉