Need to copy a table in MySQL?  Real easy to do, just run the following command:

CREATE TABLE new_table SELECT * FROM original_table

Not only does it copy the structure, it inserts each record from the original table.

Categories: Uncategorized


Leave a Reply

Avatar placeholder

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.