INSERT INTO SELECT与SELECT INTO FROM

INSERT INTO SELECT语句

语句形式为：Insert into Table2(field1,field2,...) select value1,value2,... from Table1

或者：Insert into Table2 select  *  from Table1

注意：（1）要求目标表Table2必须存在，并且字段field,field2...也必须存在

 

例如

INSERT INTO student(s_id,s_name,s_birth,s_sex)  SELECT '012','李飞',s_birth,s_sex FROM student s where s.s_id='01'

SELECT INTO  FROM语句

SELECT  V1,V2 INTO TABLE2 FROM TABLE1 

表TABLE2不存在