SELECT HOUR(e.time) as Hour,count(*) as Count
FROM error_log e
WHERE e.date = '2017-09-02'
GROUP BY HOUR(e.time) ORDER BY Hour(e.time);
原文:https://blog.csdn.net/qq_28766327/article/details/77856896
SELECT HOUR(e.time) as Hour,count(*) as Count
FROM error_log e
WHERE e.date = '2017-09-02'
GROUP BY HOUR(e.time) ORDER BY Hour(e.time);
原文:https://blog.csdn.net/qq_28766327/article/details/77856896
本文标题:一段时间每小时
本文链接:https://www.haomeiwen.com/subject/qlrtdctx.html
网友评论