从子查询更新多列

您只需将表加入子查询中即可进行一些计算，

UPDATe  records a        INNER JOIN        ( SELECT  blah,          COUNT(*) totalCount,         SUM(amount) totalSum FROM    leads_table GROUP   BY blah        ) b ON  b.blah = a.blahSET     a.leads = b.totalCount        a.earnings = b.totalSum