boywhoroared/CopyTable.sql

Created June 15, 2011 18:27

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/boywhoroared/1027744.js"></script>
Save boywhoroared/1027744 to your computer and use it in GitHub Desktop.

Download ZIP

MYSQL: Copy a table from one schema to another.

Raw

CopyTable.sql

	USE db2;

	CREATE TABLE table2 LIKE db1.table1;

	INSERT INTO table2
	SELECT * FROM db1.table1;

jgdodson commented Nov 21, 2018

Here's a link to the related Stack Overflow discussion. link

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment