SQL语句中怎么将一张表的某几列数据复制到另一张表中去？

把students的s_no和s_name复制到stu1的no和name中

当新表没有创建时
create table stu1 as select s_no , s_name from students;
当新表已经创建
insert into stu1(s_no,s_name) select students.s_no,students.s_name from students;