我需要一个查询,该查询每小时返回过去 48 小时的计数。 到目前为止,我尝试了以下任一方法:
SELECT count(*), date_format(created, '%H:%i - %d/%m/%y') as datecreated
FROM mimesi_indexer.served_clips
where created > NOW() - INTERVAL 24 HOUR
group by floor(hour(created))
order by created ASC
和:
SELECT count(*), date_format(created, '%H:%i - %d/%m/%y') as datecreated
FROM mimesi_indexer.served_clips
where created > NOW() - INTERVAL 48 HOUR
group by floor(hour(created))
order by created ASC
但这些都没有给出想要的结果。 你对我怎么做有什么想法吗? 谢谢
如果你想要每小时,你不想要这个:
SELECT count(*), date_format(created, '%H - %d/%m/%y') as datecreated
FROM mimesi_indexer.served_clips
where created > NOW() - INTERVAL 24 HOUR
group by date_format(created, '%H - %d/%m/%y')
order by min(created) ASC;
也就是说,您需要包括日期和小时 - 并从datecreated
中删除分钟。