mysql 实现查询用户连续登录的最大天数
一、创建测试表create table tmp_bzs_0526(id VARCHAR(100) comment 'id',pday VARCHAR(100) comment 'pday');select * from tmp_bzs_0526;二、插入测试数据insert into tmp_bzs_0526(id,pday) values ('A','20200501');insert into tmp_bzs_0526(id,pday) values ('A','20200502