Mysql查询？很急，坐等

Question

a表id相同的记录将num求平均值，然后插入到b表对应的id记录avg字段上

Answer 1

UPDATE b SET b.avg = (SELECT avg(a.num) as avg from a GROUP BY a.id HAVING a.id = b.id);