来源:https://deepinout.com/mysql/mysql-questions/t_how-can-i-clone-duplicate-the-table-along-with-its-data-trigger-and-indexes.html
1. 复制表结构&数据
CREATE TABLE new_table_name AS SELECT * FROM original_table_name;
或者
-- 复制表结构
CREATE TABLE newtable LIKE oldtable;
-- 倒入旧表的数据
INSERT INTO newtable SELECT * FROM oldtable;
-- 只复制表结构
CREATE TABLE tbl_new AS SELECT * FROM tbl_old;
2. 只复制表结构
CREATE TABLE new_table_name AS SELECT * FROM original_table_name WHERE 1=0;
3. 创建表索引和触发器
CREATE TABLE new_table_name AS SELECT * FROM original_table_name;
-- 创建所以和触发器
CREATE INDEX new_index_name ON new_table_name(column_name);
CREATE TRIGGER new_trigger_name AFTER INSERT ON new_table_name BEGIN ... END;
4. 复制表到另一个数据库
CREATE TABLE new_database_name.new_table_name AS SELECT * FROM original_database_name.original_table_name;