SELECT DATE_FORMAT(create_time,'%Y-%m-%d'),COUNT(message_num) AS messageNum FROM shop_message
WHERE STATUS = 1 AND object_type = 0 AND shop_id = 2510 AND DATE_FORMAT(create_time,'%Y-%m-%d')>= DATE_FORMAT('2021-05-04','%Y-%m-%d')
AND DATE_FORMAT(create_time,'%Y-%m-%d')<= DATE_FORMAT('2021-05-26','%Y-%m-%d')
GROUP BY DATE_FORMAT(create_time,'%Y-%m-%d')
mysql 按日期分组统计数据
最新推荐文章于 2024-02-21 09:24:58 发布