插入数据

语法
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';