insert into select和select into from 区别

复制表数据

insert into (table2)(v1,v2)select(c1,c2) from table1

table2必须存在

select (c1,c2) into table2 from table1

table2不存在,插入时会自动创建table2,并将table1中的指定数据复制到table2中