MySQL页面访问统计及排名情况

昨天24小时分时

SELECT td AS showhour FROM ( SELECT DATE_ADD(CURDATE(), INTERVAL -1 HOUR) as td UNION ALL SELECT DATE_ADD(CURDATE(), INTERVAL -2 HOUR) UNION ALL SELECT DATE_ADD(CURDATE(), INTERVAL -3 HOUR) UNION ALL SELECT DATE_ADD(CURDATE(), INTERVAL -4 HOUR) UNION ALL SELECT DATE_ADD(CURDATE(), INTERVAL -5 HOUR) UNION ALL SELECT DATE_ADD(CURDATE(), INTERVAL -6 HOUR) UNION ALL SELECT DATE_ADD(CURDATE(), INTERVAL -7 HOUR) UNION ALL SELECT DATE_ADD(CURDATE(), INTERVAL -8 HOUR) UNION ALL SELECT DATE_ADD(CURDATE(), INTERVAL -9 HOUR) UNION ALL SELECT DATE_ADD(CURDATE(), INTERVAL -10 HOUR) UNION ALL SELECT DATE_ADD(CURDATE(), INTERVAL -11 HOUR) UNION ALL SELECT DATE_ADD(CURDATE(), INTERVAL -12 HOUR) UNION ALL SELECT DATE_ADD(CURDATE(), INTERVAL -13 HOUR) UNION ALL SELECT DATE_ADD(CURDATE(), INTERVAL -14 HOUR) UNION ALL SELECT DATE_ADD(CURDATE(), INTERVAL -15 HOUR) UNION ALL SELECT DATE_ADD(CURDATE(), INTERVAL -16 HOUR) UNION ALL SELECT DATE_ADD(CURDATE(), INTERVAL -17 HOUR) UNION ALL SELECT DATE_ADD(CURDATE(), INTERVAL -18 HOUR) UNION ALL SELECT DATE_ADD(CURDATE(), INTERVAL -19 HOUR) UNION ALL SELECT DATE_ADD(CURDATE(), INTERVAL -20 HOUR) UNION ALL SELECT DATE_ADD(CURDATE(), INTERVAL -21 HOUR) UNION ALL SELECT DATE_ADD(CURDATE(), INTERVAL -22 HOUR) UNION ALL SELECT DATE_ADD(CURDATE(), INTERVAL -23 HOUR) UNION ALL SELECT DATE_ADD(CURDATE(), INTERVAL -24 HOUR) ORDER BY td )a

今天过去的11个小时

SELECT td AS showhour FROM ( SELECT NOW() AS td UNION ALL SELECT DATE_ADD(NOW(), INTERVAL -1 HOUR) UNION ALL SELECT DATE_ADD(NOW(), INTERVAL -2 HOUR) UNION ALL SELECT DATE_ADD(NOW(), INTERVAL -3 HOUR) UNION ALL SELECT DATE_ADD(NOW(), INTERVAL -4 HOUR) UNION ALL SELECT DATE_ADD(NOW(), INTERVAL -5 HOUR) UNION ALL SELECT DATE_ADD(NOW(), INTERVAL -6 HOUR) UNION ALL SELECT DATE_ADD(NOW(), INTERVAL -7 HOUR) UNION ALL SELECT DATE_ADD(NOW(), INTERVAL -8 HOUR) UNION ALL SELECT DATE_ADD(NOW(), INTERVAL -9 HOUR) UNION ALL SELECT DATE_ADD(NOW(), INTERVAL -10 HOUR) UNION ALL SELECT DATE_ADD(NOW(), INTERVAL -11 HOUR) ORDER BY td )a

以上所述是小编给大家分享的MySQL页面访问统计及排名情况，希望对大家有所帮助。

您可能感兴趣的文章:

mysql分组取每组前几条记录(排名) 附group by与order by的研究MySQL中给自定义的字段查询结果添加排名的方法Mysql排序获取排名的实例代码MYSQL实现排名及查询指定用户排名功能（并列排名功能）实例代码