意会一下

insert into B表 (a, b, c, ...) select a, b, c, ... from A表 where ...