create table TABLE2 as select * from table1 t where id='A' insert into table2 select * from table1 where id='B'