xxxxxxxxxx
CREATE TABLE New_Table_name AS SELECT * FROM Existing_table_Name;
xxxxxxxxxx
-- Copy datas and structure:
CREATE TABLE new_table AS SELECT * FROM my_table;
-- Copy structure only:
CREATE TABLE new_table AS SELECT * FROM my_table WHERE 1=0;