MySQL按日期分组并统计截止当前时间的总数（实例教程）

SELECT
    reg_time,
    total1 as ‘小计‘,
    @total := @total + total1 AS ‘总计‘
FROM
    (
        SELECT
            date(reg_time) AS reg_time,
            sum(users) AS total1
        FROM
            test
        GROUP BY
            date(reg_time)
    ) AS temp,
    (SELECT @total := 0) AS T1
ORDER BY
    reg_time;