Skip to content

Instantly share code, notes, and snippets.

@anytizer

anytizer/clone-table.sql

Created March 3, 2014 14:09
Show Gist options
  • Save anytizer/9325655 to your computer and use it in GitHub Desktop.
Save anytizer/9325655 to your computer and use it in GitHub Desktop.
Download ZIP
Clone table
Raw
clone-table.sql
DROP TABLE target.table;
CREATE TABLE target.table LIKE source.table;
INSERT INTO target.table SELECT * FROM source.table;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment