假设有两个表:表A和表B。表A包含两列,分别是分组列group和计数列count。表B包含两列,分别是分组列group和计数列count。
你可以按照如下步骤将表B的计数加到表A的分组计数中:
CREATE TABLE tempA AS
SELECT group, SUM(count) AS total_count
FROM tableA
GROUP BY group;
CREATE TABLE tempB AS
SELECT group, SUM(count) AS total_count
FROM tableB
GROUP BY group;
UPDATE tableA
SET count = count + (SELECT total_count FROM tempB WHERE tempB.group = tableA.group)
WHERE EXISTS (SELECT 1 FROM tempB WHERE tempB.group = tableA.group);
这样,表A的分组计数就会加上表B的计数。