该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
数据表结构
CREATE TABLE `prod` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) DEFAULT NULL,
`create_time` timestamp COMMENT '登录时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_bin
测试数据
INSERT INTO `prod` VALUES (1, 1, '2014-1-1 21:00:00');
INSERT INTO `prod` VALUES (2, 1, '2014-1-2 15:37:57');
INSERT INTO `prod` VALUES (3, 2, '2014-1-1 09:00:00');
INSERT INTO `prod` VALUES (4, 2, '2014-1-2 09:00:00');
INSERT INTO `prod` VALUES (5, 1, '2014-1-4 10:00:00');
INSERT INTO `prod` VALUES (6, 1, '2014-1-5 12:00:00');
INSERT INTO `prod` VALUES (7, 2, '2014-1-10 00:00:00');
INSERT INTO `prod` VALUES (8, 2, '2014-1-11 13:00:00');
INSERT INTO `prod` VALUES (10, 2, '2014-1-12 12:00:00');
INSERT INTO `prod` VALUES (11, 1, '2014-1-8 06:00:00');
INSERT INTO `prod` VALUES (12, 2, '2014-1-11 21:00:00');
想要得到的结果是每个uid连续登录的最大天数,最好还有累计天数,两个需求分两次查出来也行
例如
uid lianxu
1 2
累计
uid lianxu
1 5
注意 如果一天登录两次或多次算一天, 谢谢大家了。