1.如果列名相同

     insert into tab_user2 select * from tab_user where site=17;

 

2.指定列名插入

     insert into tab_user2(id,account) select id,account from tab_user where site=3;