mysql 累加求和

set @csum := 0;
SELECT temp.*,(@csum := total + @csum) as csums from (
select count(1) as total,month(openedDate) as date from zt_bug where openedDate >= CONCAT(YEAR(NOW()), '-01-01 00:00:01') and `status` <> 'closed' GROUP BY date
)as temp

参考：https://blog.csdn.net/qcyfred/article/details/78045857