复制表格

要复制表,只需执行以下操作:

CREATE TABLE newtable LIKE oldtable; 
INSERT newtable SELECT * FROM oldtable;