将B表的数据全部复制到A表: insert into B select * from A; 如果过是想要复制部分数据,还可以添加查询条件:insert into B select * from A where ...;