How to clone a table structure in MySQL

I have often needed to clone a table without it’s data in MySQL.

Oftentimes this has been because I have a continually growing temporary table and I just need to clear up some disk space. And it’s a lot faster and more guaranteed than trying to delete and optimise the table.

Clone a table structure without it’s data

Let’s say that your table in question is called table1:

create table table1tmp like table1; drop table table1; rename table table1tmp to table1;
Code language: SQL (Structured Query Language) (sql)

If you run the above queries either in quick succession, or altogether in a single statement, you will notice that this is a very fast method even on very big tables.

Another article exists to clone and drop tables over here.

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments