mysql获取连续登陆大于等于3天的用户id

 

建表

CREATE TABLE `user_login` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `login_date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

插入数据

INSERT INTO `user_login` (`id`, `user_id`, `login_date`) VALUES (1, 1, '2020-5-13');
INSERT INTO `user_login` (`id`, `user_id`, `login_date`) VALUES (2, 1, '2020-5-15');
INSERT INTO `user_login` (`id`, `user_id`, `login_date`) VALUES (3, 1, '2020-5-14');
INSERT INTO `user_login` (`id`, `user_id`, `login_date`) VALUES (4, 1, '2020-5-17');
INSERT INTO `user_login` (`id`, `user_id`, `login_date`) VALUES (5, 2, '2020-5-15');
I