MySQL按月统计累计人数

MySQL按月统计累计人数

SELECT tables.*,(@i:=@i+tables.sum) as totalNum
FROM
(
SELECT DATE_FORMAT(create_time,'%Y-%m') AS month,COUNT(1) AS sum FROM user GROUP BY month
)tables
  CROSS JOIN (select @i := 0) x;