insert into A select * from B where 1=1 

A表中字段与B表要相同