mysql 中间表重命语法

中间表命名规则
insert into statistic(productid,in_gross)
(
select db.productid db.sa from
(select productid,sum(amount) sa from supply GROUP BY productid) db
);