把一个数据表的特定内容复制到另一个数据表

insert  into bbb(字段列表)select 字段列表from aaawhere userid=100;

 

 

insert bbb(d,e,f)select a,b,cfrom aaa;

 

insert fields into tableA select fields from tableB where condition;