MySQL统计每小时、每分钟的数据
# 每小时数量SELECT create_time,HOUR(create_time) as Hour,count(1) as Count FROM table_name WHERE create_time between '2021-09-01 00:00:00' and now() GROUP BY HOUR(create_time) ORDER BY Hour(create_time);# 每分钟数量SELECT create_time,MINUTE(create_time) as MINUTE
原创
2021-09-01 16:13:32 ·
3019 阅读 ·
0 评论