Cloning table structure

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_customers
Create 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=utf8mb4
1 row in set (0.00 sec)