mysql怎么查询每个小时的数据

可以借助于mysql的日期函数，这里提供下SQL的思路：

SELECT u.hour,

COUNT(*)

FROM (SELECT 获取create_time的小时部分 AS hour

FROM user

WHERE 获取create_time的日期部分 = 某个日期) u

GROUP BY u.hour

具体的mysql日期函数可以查一下API。

select hour(create_time) AS saleHour, count(id) AS saleCount

from tableName where date_format(create_time, ‘%Y-%m-%d’ ) = ‘2021-09-07’

group by hour(create_time)

---