如何更新MySQL中另一个表的合计结果的字段? [英] How to update fields that is the aggregate result of another table in MySQL?

问题描述

UPDATE  a JOIN  b ON a.app_id=b.app_id GROUP BY a.app_id SET 

remark_avg=AVG(b.score),remark_count=COUNT(b.id);

以上基本上是我想做的，但这不是有效的MySQL语句，如何正确编写?

The above is basically what I want to do,but it's not a valid MySQL statement,how to write it correctly?

推荐答案

    UPDATE a
INNER JOIN (SELECT AVG(b.score) avg_score,
                   COUNT(b.id) cnt_id,
                   b.app_id
              FROM b
          GROUP BY b.app_id) x ON x.app_id = a.app_id
       SET remark_avg = x.avg_score,
           remark_count = x.cnt_id;

这篇关于如何更新MySQL中另一个表的合计结果的字段?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！