MySQL: How to clone a table

Ever wanted to, for some reason, clone a database table? Don’t really want to export anything or figure out what statement was used to create that table? Turns out that’s a lot easier to do than I thought it was.

Stumbled over a blog post on how you can copy a MySQL table with schema and keys, and boy was it easy.

CREATE TABLE newtable LIKE oldtable;

And that’s it! Want the data copied over as well?

INSERT INTO newtable SELECT * FROM oldtable;

Super easy! :D

  • Loumil4

    awesome; just what i was looking for, thanks.

  • Tom

    I love blog posts that are short and to the point. Easy and useful, thanks :)

  • Shane

    Thanks just what i was looking for.