mysql的分钟或小时间隔计算数据总量

统计1分钟内的数据总量

select 
    date_format(times,'%Y-%m-%d %H:%i') as timeData,
    count(ID) as Num
    from table01 
    group by timeData;

统计5分钟内容的数据总量

select
    concat(date_format(times,'%Y-%m-%d %H:%i') ,LPAD(date_format(times,'%i') div 5 * 5,2,0)) as timeData,
    count(ID) as Num
    from table01
    group by timeData;

统计30分钟内的数据总量

select
    concat(date_format(times,'%Y-%m-%d %H:%i') ,LPAD(date_format(times,'%i') div 30 * 30,2,0)) as timeData,
    count(ID) as Num
    from table01
    group by timeData;

统计60分钟内的数据总量

select 
    date_format(times,'%Y-%m-%d %H:00:00') as timeData,
    count(ID) as Num
    from table01 
    group by timeData;