Skip to content

Instantly share code, notes, and snippets.

@chiragparekh
Created April 5, 2014 10:15
Show Gist options
  • Save chiragparekh/9990000 to your computer and use it in GitHub Desktop.
Save chiragparekh/9990000 to your computer and use it in GitHub Desktop.
Copy MySQL Table Structure with Data
CREATE TABLE new_table_name LIKE table_name;
INSERT new_table_name SELECT * FROM table_name;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment