You can clone the structure of one table into a new table:
mysql> CREATE TABLE new_customers LIKE customers;Query OK, 0 rows affected (0.05 sec)
You can verify the structure of the new table:
mysql> SHOW CREATE TABLE new_customers\G*************************** 1. row *************************** Table: new_customersCreate Table: CREATE TABLE `new_customers` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `first_name` varchar(20) DEFAULT NULL, `last_name` varchar(20) DEFAULT NULL, `country` varchar(20) DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb41 row in set (0.00 sec)
