MySQL中統計壹天之內每個時間段內的數據，很急

時間段統計，可以采用 hour(subscribe_time) 取出小時然後分層。思路：

select

uid

,CASE WHEN HOUR(subscribe_time) BETWEEN 0 AND 1 THEN '00:00:00'

WHEN HOUR(subscribe_time) BETWEEN 2 AND 3 THEN '02:00:00'

...

ELSE '23:00:00' END -- 生成時間分層部分，insert前外層sql加上日期後作為唯壹的時間值

,COUNT(*)

FROM yht_fans WHERE subscribe_time>=UNIX_TIMESTAMP(CURDATE()) and subscribe_time<=UNIX_TIMESTAMP(CURDATE())+86400

GROUP BY 1,2

上一篇:iris有什麽含義嗎？

下一篇:當下最紅的女星是誰？