MySQL 统计

1.统计 七天 前 人数
select count() from your_table where last_login_time> date_add(date(now()), interval -7 day);
2.按天累计人数
select DATE_FORMAT(last_login_time, '%Y-%m-%d') as dd, count() as '每日' from your_table group by dd order by dd desc;
3.按月统计
select DATE_FORMAT(last_login_time, '%Y-%m') as dd, count(*) as '每月' from your_table group by dd order by dd desc;