MySQL实现累加功能

MySQL实现累加功能

需求：为实现total累计求和的功能。

第一种方法：根据子查询

一张视图。

首先把你的数据以月聚合成如上图；
然后对上表进行如下语句

• select jhsj,month(wcsj)as mth ,sum(xlcd),(select sum(xlcd) from
  AF_JJYJ_JDGL as a where a.wcsj<= b.wcsj) as total from AF_JJYJ_JDGL
  as b

使用临时变量

• select “计划” as JHSJ, mth, TCXLQC AS amount, @xl_jh:= @xl_jh + TCXLQC
  AS total from (SELECT MONTH(WCSJ) as mth, SUM(XLCD) AS ‘TCXLQC’
  from AF_JJYJ_JDGL ) ) a, (select @xl_jh:= 0) t