Skip to content

Instantly share code, notes, and snippets.

@sayasuhendra
Created June 12, 2014 14:26
Show Gist options
  • Save sayasuhendra/b7b7645979c6a0c26625 to your computer and use it in GitHub Desktop.
Save sayasuhendra/b7b7645979c6a0c26625 to your computer and use it in GitHub Desktop.
MySQL: duplicate table query
CREATE TABLE recipes_new LIKE production.recipes; INSERT recipes_new SELECT * FROM production.recipes;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment