insert into select
要求tab2存在:
insert into tab2(c1,c2) select c1,c2 from tab1;
要求tab2不存在:
select c1,c2 into tab2 from tab1;
要求tab2存在:
insert into tab2(c1,c2) select c1,c2 from tab1;
要求tab2不存在:
select c1,c2 into tab2 from tab1;