每隔五分钟
SELECT concat( date_format(create_time, '%Y-%m-%d %H:' ) , floor( date_format(create_time, '%i' ) /5 ) ) AS 时间段, count( * ) as 数量
FROM 表名
GROUP BY 时间段
每隔五小时
SELECT concat( date_format(create_time, '%Y-%m-%d:' ) , floor( date_format(create_time, '%H' ) /5 ) ) AS 时间段, count( * ) as 数量
FROM user
GROUP BY 时间段
每隔五天
SELECT concat( date_format(create_time, '%Y-%m-%d,' ) , floor( date_format(create_time, '%d' ) /5 ) ) AS 时间段, count( * ) as 数量
FROM user
GROUP BY 时间段
每隔五月
SELECT concat( date_format(create_time, '%Y-%m,' ) , floor( date_format(create_time, '%m' ) /5 ) ) AS 时间段, count( * ) as 数量
FROM user
GROUP BY 时间段
每隔两年
SELECT concat( date_format(create_time, '%Y,' ) , floor( date_format(create_time, '%Y' ) /2 ) ) AS 时间段, count( * ) as 数量
FROM user
GROUP BY 时间段