高效的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
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
