INSERT INTO SELECT语句
要求目标表必须存在(可以插入常量)
insert into person (name) select name from person where id=1;
SELECT INTO FROM语句
要求目标表不存在,在插入时会自动创建表
create table person1 as select * from person ;
http://www.cnblogs.com/freshman0216/archive/2008/08/15/1268316.html