概述
假设我们有一张表,记录了用户的登入、登出信息,我们需要根据这些信息统计用户的在线时长,相应的设置用户等级,就像挂QQ升级
表数据如下:
mysql> select * from user_sessions;
+----+----------+-------+----------+----------+
| id | platform | usr | start | end |
+----+----------+-------+----------+----------+
| 1 | web | user1 | 08:30:00 | 10:30:00 |
| 2 | web | user2 | 08:30:00 | 08:45:00 |
| 3 | web | user1 | 09:00:00 | 09:30:00 |
| 4 | web | user2 | 09:15:00 | 10:30:00 |
| 5 | web | user1 | 09:15:00 | 09:30:00 |
| 6 | web | user2 | 10:30:00 | 14:30:00 |
| 7 | web | user1 | 10:45:00 | 11:30:00 |
| 8 | web | user2 | 11:00:00 | 12:30:00 |
| 9 | app | user1 | 08:30: