由于时间戳每一秒都不同,所以可以分组,但无法查询该字段,所以先转为天的格式来查看
SELECT
count(*) AS counter,
timedate
FROM
(
SELECT
*,
date_format(from_unixtime(c.addtime), '%Y-%m-%d') AS timedate
FROM
l_tour_member_order AS c
where
productautoid IN (30, 33, 35, 37, 38, 39, 484, 488, 494)
) as tmp
WHERE
timedate >= '2021-07-16'
GROUP BY
timedate
该订单表里addtime是时间戳,但要查询最近一个月每天订单多少,先查询该表信息并附加一个新字段timedate,整个查询数据作为附加表来查询,并按该字段分组