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! 🙃