INSERT...SELECT 语句和SELECT...INTO 语句

INSERT...SELECT 语句语法
insert table_name [column_list]
select column_list
from table_list
where search_condirions
INSERT...SELECT 语句是将已有的数据插入到已有的数据表里面

SELECT...INTO 语句语法
select <select_list>
into new_table
from table_name
where <search_condition>
select...into 语句是新建一个数据表