Create the same table structure (schema) from another table in MySQL

Without coping data, we can easy to create the same table structure (schema) using the below SQL command.

CREATE TABLE NewTableName SELECT * FROM FromTableName LIMIT 0

Leave a Comment