数据库复制相同表语句

表一

 

      create table aa(aa varchar(50),bb varchar(50));

      insert into aa values('aa','aa');

      insert into aa values('aa','aa');

      insert into aa values('aa','aa');

       create table aa(aa varchar(50),bb varchar(50)); 

      insert into bb(aa,bb)  select * from aa;// SELECT aa,bb from aa;是一样的。

      select * from bb;