Skip to content

Instantly share code, notes, and snippets.

@bastiankoetsier

bastiankoetsier/copy-table

Created November 24, 2014 08:52
Show Gist options
  • Save bastiankoetsier/2f5b40014504441b0486 to your computer and use it in GitHub Desktop.
Save bastiankoetsier/2f5b40014504441b0486 to your computer and use it in GitHub Desktop.
Download ZIP
If you want to copy a table from one Database to another database
Raw
copy-table
CREATE TABLE db2.table LIKE db1.table;
INSERT INTO db2.table SELECT * FROM db1.table;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment