Create a new table from merging two tables with union

Question

I have two tables with the same columns.

I can merge them with UNION

select * from  table1
union
select * from table2;

How do I create a new table with the same contents and columns as that query?

Answer 1

You can use CREATE TABLE ... SELECT statement.

CREATE TABLE new_table
  SELECT * FROM table1
    UNION
  SELECT * FROM table2;

Answer 2

create table new_table as
select col1, col2 from table1 
union 
select col1, col2 from table2

Make sure you select same set of columns from tables in union.