MySQL快速複製Table

複製schema
create table new_table like old_table;


複製data
insert into new_table select * from old_table;


複製schema和data
select * into new_table  from old_table;


複製指定欄位data
insert into new_table(column1, column2) select (column1, column2) from old_table;


*注意Table Engine和Character Set