高效的INSERT INTO SELECT和SELECT INTO

1、INSERT INTO SELECT，目标表必须存在，才可批量插入

INSERT INTO 目标表Table(field1,field2,field2,...) SELECT value1,value2,123,... from Table1

2、SELECT INTO，目标表必须不存在，会自动创建

SELECT vale1,value2 INTO 目标表Table from Table1