phone

How to copy a table in phpmyadmin

If you dabble with phpmyadmin as much as I do, then you know how just a few simple codes can make work much easier. There are two ways to copy a table in phpmyadmin.

The first way is to make a dump copy of your table (export table) and then import with a new name

The second way is much easier with the use of mysql CREATE command

CREATE table newtable SELECT * FROM oldtable

There may be a third way, but that is through mysql shell command

php myadmin

Grow Your Business. Call: 256-361-9080

Leave a Reply