Re: 按月统计了一下截止到今天的注册人数合计。
发表于 : 2010-06-09 17:29
老大能不能统计下
平均日在线数量时间分布图
平均日注册时间分布图
谢谢啦
平均日在线数量时间分布图
平均日注册时间分布图
谢谢啦
哇哇,真的诶,没认出来。。。不太适应daf3707 写了:神换头了?
delectate 写了:老大能不能统计下
平均日在线数量时间分布图
平均日注册时间分布图
谢谢啦
代码: 全选
mysql> select Hour(from_unixtime(user_lastvisit)) as Hour, count(*) from phpbb_users group by Hour;
+------+----------+
| Hour | count(*) |
+------+----------+
| 0 | 7422 |
| 1 | 4336 |
| 2 | 2606 |
| 3 | 1694 |
| 4 | 1150 |
| 5 | 932 |
| 6 | 1139 |
| 7 | 2136 |
| 8 | 39200 |
| 9 | 10017 |
| 10 | 12432 |
| 11 | 13120 |
| 12 | 11411 |
| 13 | 12627 |
| 14 | 12854 |
| 15 | 13266 |
| 16 | 14519 |
| 17 | 13136 |
| 18 | 10425 |
| 19 | 10804 |
| 20 | 11875 |
| 21 | 13174 |
| 22 | 13638 |
| 23 | 11230 |
+------+----------+
24 rows in set (2.58 sec)
mysql> select Hour(from_unixtime(user_regdate)) as Hour, count(*) from phpbb_users group by Hour;
+------+----------+
| Hour | count(*) |
+------+----------+
| 0 | 7837 |
| 1 | 4821 |
| 2 | 2845 |
| 3 | 1774 |
| 4 | 1236 |
| 5 | 1049 |
| 6 | 1456 |
| 7 | 2632 |
| 8 | 7180 |
| 9 | 13005 |
| 10 | 16048 |
| 11 | 15190 |
| 12 | 13395 |
| 13 | 15043 |
| 14 | 15345 |
| 15 | 15581 |
| 16 | 16196 |
| 17 | 14098 |
| 18 | 11895 |
| 19 | 12428 |
| 20 | 13807 |
| 21 | 15014 |
| 22 | 15066 |
| 23 | 12203 |
+------+----------+
24 rows in set (1.50 sec)
请看26楼HuaChong 写了:笔记本被借走了,不然可以用gnuplot画个图出来直观的表述一下