sql 从一张表将内容复制到另一张表

1.完全复制

insert into table1 select   *    from table2 (完全复制)insert into table1 select   distinct   *   from table2(不复制重复纪录）insert into table1 select   top 5 *   from   table2 (前五条纪录)1、复制表结构及数据到新表CREATE TABLE 新表SELECT distinct * FROM 旧表2、只复制表结构到新表CREATE TABLE 新表SELECT * FROM 旧表WHERE 1=2或CREATE TABLE 新表LIKE 旧表