查询每日用户新增量
select DATE_FORMAT(created_id,'%Y-%m-%d') date,
COUNT(day(created_id)) total from user
group by day(created_id)
select DATE_FORMAT(created_id,'%Y-%m-%d') date,
COUNT(day(created_id)) total from user
WHERE created_id<'2019-05-01' //添加条件
group by day(created_id)
每月用户新增量
select DATE_FORMAT(created_id,'%Y-%m') date,
COUNT(month(created_id)) total from user
group by month(created_id)
每年用户新增量
select DATE_FORMAT(created_id,'%Y) date,
COUNT(year(created_id)) total from user
group by year(created_id)
最近一周用户新增量
DATE_ADD(CURDATE(),INTERVAL -7 DAY)
SELECT DATE(created_id) as date,COUNT(*) FROM user
WHERE created_id>DATE_ADD(CURDATE(),INTERVAL -7 DAY)
GROUP BY day(created_id)
