select sno,sname into stu from student --创建表并添加记录
select sno,sname into stu1 from student where 1=0 --只复制表结构, where条件永远为false
insert into stu(sno,sname) select sno,sname from student --复制表数据
insert into logins..stu(sno,sname) select sno,sname from test..student --复制表数据到不同数据库,把test数据库中的student表,复制到logins数据库中的stu表