mysql 连续打卡天数_Mysql求最新连续打卡天数

drop table if exists `t`;

create table `t`(

`id` int unsigned auto_increment,

`uid` int unsigned,

`b` int unsigned,

`c` int unsigned,

primary key(`id`)

);

insert into `t`(`uid`, `b`, `c`) values(1, 1, 1);

insert into `t`(`uid`, `b`, `c`) values(2, 1, 1);

insert into `t`(`uid`, `b`, `c`) values(3, 1, 1);

insert into `t`(`uid`, `b`, `c`) values(1, 2, 1);

insert into `t`(`uid`, `b`, `c`) values(2, 2, 1);

insert into `t`(`uid`, `b`, `c`) values(3, 2, 1);

insert into `t`(`uid`, `b`, `c`) values(1, 3, 0);

insert into `t`(`uid`, `b