语法
1>insert into 表名【（列名,列名,列名…）】
values (值，值,值)
注意：值要和列名对应
2>create table 表名【（列名,列名,列名…）】 as 子查询
create table peopel(id,name) as select id,name from student;
3 insert into 表名【（列名,列名,列名…）】
子查询
注意：值要和列名对应
insert into peopel(id,name)
select sno,sname from student where sno='s001';
