mysql里连续天数

SELECT DATEDIFF('2023-10-10', '2023-10-01') AS days;

SELECT date, 
       IF(@prev_date = date - 1, @group := @group, @group := @group + 1) AS group_id,
       @prev_date := date
FROM logs, (SELECT @group := 0, @prev_date := NULL) AS vars
ORDER BY date;

SELECT DATE_ADD('2023-10-01', INTERVAL n DAY) AS date
FROM (
    SELECT @rownum:=@rownum+1 AS n
    FROM (SELECT 0 UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) r,
         (SELECT 0 UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) s,
         (SELECT 0 UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) t,
         (SELECT @rownum:=-1) vars
) AS nums
WHERE DATE_ADD('2023-10-01', INTERVAL n DAY) <= '2023-10-10';