求更有效率的mysql语句：Insert into 。。group by。。的多个结果到新表

2015-08-17 10:46:22 415 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

技术小米之MySQL GROUP BY 语句 MySQL GROUP BY 语句 GROUP BY 语句根据一个或多个列对结果集进行分组。在分组的列上我们可以使用 COUNT, SUM, AVG,等函数。 GROUP BY 语法 SELECT column_name, function(column_name) FROM table_name WHERE column_name operator value GROUP BY co... 阅读详情

我想把表2中的结果赋给表1
现在的语句比较冗余如下所示，求更有效率的语句，先谢谢各位高手了：
insert into `Table 1` (`Region`, `Group1`) /*插入group1
select * from
(
select `Region`,sum(`Criteria`) as Group1 from `Table2`
where `Criteria`="Group1"
group by `Criteria`
)var
on duplicate key update `Group1`=var.Group1

insert into `Table 1` (`Region`, `Group2`) /*插入group2
select * from
(
select `Region`,sum(`Criteria`) as Group2 from `Table2`
where `Criteria`="Group2"
group by `Criteria`
)var
on duplicate key update `Group2`=var.Group2

insert into `Table 1` (`Region`, `Group3`) /*插入group3
select * from
(
select `Region`,sum(`Criteria`) as Group3 from `Table2`
where `Criteria`="Group3"
group by `Criteria`
)var
on duplicate key update `Group3`=var.Group3

...全文