此查询将创建一个连续几天为1的列,如果日期不连续则为0.

select a.*,coalesce(date_diff(a.date,@prevDate),0) = 1 as consecutiveDay -- '1' if the days are consecutive,-- '0' otherwise
                                                                      -- (The First row will be 0),@PRevDate := a.date as this_date -- You need to Store the date of the current record
                                       -- to compare IT with the next one
From
    (select @prevDate := null) as init  -- This is where you initialize the temp 
                                        -- VARiable that will track the prevIoUs date,yourTable as a
-- WHERE -- (Put any where conditions here)
order by a.date;

现在,您可以将使用上述查询的那些作为第二个查询的行源进行求和：

select sum(consecutiveDays) as consecutiveDays
from 
    ( select a.*,0) = 1 as consecutiveDay,@prevDate := a.date as this_date
      from (select @prevDate := null) as init,yourTable as a
      -- WHERE -- (add where conditions here)
      order by a.date
    ) as b

希望这可以帮助