MySQL - Duplicate table

Mysql

Mysql Problem Overview

I need to duplicate a table in MySQL, making the new table empty. That is, I need to copy only the structure of an existing table to a new one.

Mysql Solutions

Solution 1 - Mysql

Try the create table LIKE syntax.

create table users2 like users;

This should give you an empty table (users2) with the same structure as the original (users).

Solution 2 - Mysql

There is also another way to create a empty table as existing table and you can use the following command also

create table a select * from users2 limit 0, 0;
Categories
Recommended Mysql Solutions

Previous Solution:

Exclude certain file extensions when getting files from a directory

C#FileDirectory

Next Solution:

Getting a list of logical drives

C#Hard Drive

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionGerardoView Question on Stackoverflow
Solution 1 - MysqlBrett BenderView Answer on Stackoverflow
Solution 2 - MysqlVineet1982View Answer on Stackoverflow