Page 1 of 1

Welcome to the Tweaking4All community forums!
When participating, please keep the Forum Rules in mind!

Topics for particular software or systems: Start your topic link with the name of the application or system.
For example “MacOS X – Your question“, or “MS Word – Your Tip or Trick“.

Please note that switching to another language when reading a post will not bring you to the same post, in Dutch, as there is no translation for that post!

MySQL/MariaDB - How...
Clear all

MySQL/MariaDB - How to duplicate a table

1 Posts
1 Users
Famed Member Admin
Joined: 11 years ago
Posts: 2638
Topic starter  

You can duplicate or "clone" a table's contents by executing a CREATE TABLE ... AS SELECT statement

CREATE TABLE new_table AS SELECT * FROM original_table;

- Cloning a big table can take a lot of time and server resources.
- This approach does not copy indexes, auto_increment definitions etc.


To do a proper clone of a table, where we inherit all table definitions, use the CREATE TABLE ... LIKE syntax.

CREATE TABLE new_table LIKE original_table;

- This copies the structure but DOES NOT copy the data.

To copy the data, you'll need INSERT ... SELECT:

INSERT INTO new_table SELECT * FROM original_table;

Caution: Copying big tables may take a lot of resources!


Like what you see and you'd like to help out? 

The best way to help is of course by assisting others with their questions here in the forum, but you can also help us out in other ways:

- Do your shopping at Amazon, it will not cost you anything extra but may generate a small commission for us,
- send a cup of coffee through PayPal ($5, $10, $20, or custom amount),
- become a Patreon,
- donate BitCoin (BTC), or BitCoinCash (BCH).