MySQL 8 Cookbook

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_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)