Skip to content

Instantly share code, notes, and snippets.

@AleksandrMihhailov

AleksandrMihhailov/Copy MySQL table to another table

Last active December 22, 2015 05:39
Show Gist options
  • Save AleksandrMihhailov/6425426 to your computer and use it in GitHub Desktop.
Save AleksandrMihhailov/6425426 to your computer and use it in GitHub Desktop.
Download ZIP
Copy table data to another table!
Raw
Copy MySQL table to another table
# Copy table data to another table.
CREATE TABLE new_table LIKE old_table;
INSERT new_table SELECT * FROM old_table;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment