複制表結構
使用(use)like

create table new_tableName like old_tableName ;

使用(use)子查詢

CREATE TABLE new_tableName SELECT * FROM old_tableName WHERE 1=2;

複制表結構及數據

CREATE TABLE new_tableName  SELECT * FROM old_tableName;

複制數據到(arrive)新表
兩個(indivual)表結構一(one)緻

INSERT INTO new_tableName   SELECT * FROM old_tableName

兩個(indivual)表結構不(No)一(one)緻

INSERT INTO new_tableName(field1,field2,.......) SELECT field1,field2,...... FROM old_tableName