mysql 日期连续

-- 检查缺失的日期
SELECT a.date
FROM (
    SELECT DATE_ADD('2023-01-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
        ORDER BY n
        LIMIT 365
    ) numbers
) a
LEFT JOIN your_table b ON a.date = b.date
WHERE b.date IS NULL;

-- 删除重复的日期数据
DELETE t1 FROM your_table t1
INNER JOIN your_table t2 
WHERE t1.id > t2.id AND t1.date = t2.date;