①
insert into table2(field1,field2) select value(field1,field2) from table1;
或者
Insert into Table2 select * from Table1
注意点:目标表Table2已存在
②
select * from Table1 into Table2;
或者
select * into Table2 from Table1;
注意点:目标表Table2插入时才创建.
①
insert into table2(field1,field2) select value(field1,field2) from table1;
或者
Insert into Table2 select * from Table1
注意点:目标表Table2已存在
②
select * from Table1 into Table2;
或者
select * into Table2 from Table1;
注意点:目标表Table2插入时才创建.