1、复制一张表结构
CREATE TABLE `your_table_name`
LIKE `destination_table_name`;
2、完全复制一张表：表结构+全部数据
CREATE TABLE list_copy_1
LIKE list;
INSERT INTO list_copy_1
SELECT *
FROM list
------------------------------------------------------------------
CREATE TABLE list_copy_2 as ( SELECT * FROM list );
