解决一个表中的数据由同表中两字段加权和得到（用触发器解决）

本次实验一张表中的90%的数据由相关连的外表（b表）数据得到，即用触发器得到。

https://blog.csdn.net/IT_95/article/details/84064958

那么如何实现这张表里面的数据得到一个总的值放在一个字段呢？

第一时间的想法是在这张表（b表）里面加触发器实现，但是触发器实现的是两张表之间的数据变化。

最后的解决方案是在a表中触发器里面加上更新字段数据指令

UPDATE db_corporatecreditscore SET IntegrityTotalScore=SolvencyIndicatorScore+ProfitabilityIndicatorScore+BusinessIndicatorScore+PerformanceIndicatorScore+DevelopmentIndicatorScore+TranceBackIndicatorScore;

连着上一个触发器，一起运行就可以实现。

触发器代码如下：

BEGIN
IF new.EventKind=1 THEN
UPDATE db_corporatecreditscore SET SolvencyIndicatorScore=SolvencyIndicatorScore+new.ScoreChange WHERE CreditCode=new.CreditCode;
END IF;
IF new.EventKind=2 THEN
UPDATE db_corporatecreditscore SET ProfitabilityIndicatorScore=ProfitabilityIndicatorScore+new.ScoreChange WHERE CreditCode=new.CreditCode;
END IF;
IF new.EventKind=3 THEN
UPDATE db_corporatecreditscore SET BusinessIndicatorScore=BusinessIndicatorScore+new.ScoreChange WHERE CreditCode=new.CreditCode;
END IF;
UPDATE db_corporatecreditscore SET IntegrityTotalScore=SolvencyIndicatorScore+ProfitabilityIndicatorScore+BusinessIndicatorScore+PerformanceIndicatorScore+DevelopmentIndicatorScore+TranceBackIndicatorScore;
END

数据库表信息如下

a表：

b表：