如果表结构相同:
1、insert into student2 select * form student1(完全复制student1表的内容)
2、insert into student2 select distinct * form student1(不复制student1表的重复内容,在oracle中适用)
表结构不同:insert into student2(a,b,c) select d,e,f from student1
如果表结构相同:
1、insert into student2 select * form student1(完全复制student1表的内容)
2、insert into student2 select distinct * form student1(不复制student1表的重复内容,在oracle中适用)
表结构不同:insert into student2(a,b,c) select d,e,f from student1