Mysql 按年度、季度、月度、周、日统计查询的例子

1.指定月内的每天用户的注册数,

select days as '时间' ,count(days) as '注册数'  from (

select date_format(REGISTER_TIME,'%Y-%m-%d') as days from bk_wappuser  where 

 date_format(REGISTER_TIME,'%Y-%m') = '2016-07') as t group by days

2 2016 每月的注册数

select DATE_FORMAT(REGISTER_TIME,'%Y-%m') as month,count(LAST_LOGIN) as '每月注册数'   
from bk_wappuser
where DATE_FORMAT(REGISTER_TIME,'%Y')=2016   
group by month   
order by month

3. 查询一天中每个小时登录的人数

select hour(LAST_LOGIN) as hour, count(1) as count  
  from bk_appuser 
  where DATE_FORMAT(LAST_LOGIN,'%Y-%m-%d') = '2016-08-17'  
  group by hour(LAST_LOGIN);  

http://wenku.baidu.com/link?url=eYWPd3mLjxm-EcW6s8aRVZ0cvMyI1Eyo24f1p4oIJpGWS7PtcbPxmlBwIzNCGD_5Ud1wISzxkZSWB9ixxfdnd4iomdxcdf6OFTTizaoMhLu