mysql 统计某字段连续出现的次数

直接上干货，测试数据如下

select distinct  dd.Num ConsecutiveNums
from  (
select d.score,
       @n :=if(@pre=score,@n+1,@n:=1) count,
       @pre:=score
from Logs d,
     (select @pre:=null, @n :=1) r ) dd
where dd.count>=3;

统计结果如下：

补充：

MySQL的 @x 是 用户自定义的变量  (User variables are written as @var_name)

@设置全局变量值:

mysql> SET @t1=0, @t2=0, @t3=0;

mysql> SELECT @t1:=(@t2:=1)[e-mail]:=4,@t1,@t2,@t3;