MySQL - Copy An Existing Table To A New Table

MySQL - Copy An Existing Table To A New Table

Use these following commands to make a copy of an existing MySQL table to a new table:

CREATE TABLE new_table_name LIKE databasename.existing_table_name
INSERT INTO new_table_name SELECT * FROM databasename.existing_table_name

The databasename is optional if we are working in the same selected database.

More info about copy table to a new table copy table using mysql mysql copy table

1 Comment Already

Pingback & Trackback

Pingback from Back Up Your MySQL Databases With MySQLDump

April 25th, 2009 @7:07 am

Related Post

Leave Your Comments Below

« PHP - IP To Numeric Value

Javascript: Open new window containing php page »