大表拆小表

小表合并大表

方式多种
INSERT INTO tableA(a字段,b字段,c字段) (select d,e,f from tableB)

如果不挑字段,直接
INSERT INTO tableA (select d,e,f from tableB)

将A表的某字段导入B表的字段中

UPDATE A表 AS a
INNER JOIN B表 AS b ON a.user_account = b.user_account 
SET
a.green_num = b.green_num,
a.purple_num = b.purple_num,
a.yuanbao_num = b.yuanbao_num,
a.zhendou_num = b.zhendou_num