Duplicate Table MySQL

First of all you create a new table that contains an identical structure to the old one this is done with LIKE.

1

CREATE TABLE newtable LIKE oldtable

With the structure setup you simply copy the contents with an INSERT query that selects everything from the old table.

1

INSERT INTO newtable SELECT * FROM 'oldtable'

Very simple and useful to remember. When you’ve become accustomed to not having to this via a query it can be a real headache to forget!

1
2

CREATE TABLE newtable LIKE oldtable;
INSERT INTO newtable SELECT * FROM 'oldtable';

Bookmark or share this page:

Related posts:

1. SQL Injections: Introduction with PHP/MySQL
2. MD5 and SHA1 “Decrypting” with PHP / MySQL

MSN Contact: contact [at] danielgibbs.net