Skip to content

Instantly share code, notes, and snippets.

@biswarupadhikari

biswarupadhikari/copy.sql

Created December 18, 2012 13:13
Show Gist options
  • Save biswarupadhikari/4327881 to your computer and use it in GitHub Desktop.
Save biswarupadhikari/4327881 to your computer and use it in GitHub Desktop.
Download ZIP
All All Mysql Data From One Table to Another
Raw
copy.sql
INSERT INTO mydb.test2 SELECT * FROM mydb.test
The above query will copy all data from test table to test2 table.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment