一步就可以了,用什么两步create table student as select 你要的字段 from 目标表 where 条件过滤望采纳!!
create table studentinfo(id varchar(10) not null,name varchar(20),primary key(id)); insert into studentinfo values(''005,'jen');