mysql构造每天的数据

CREATE TABLE daily_data (
    id INT AUTO_INCREMENT PRIMARY KEY,
    date DATE NOT NULL,
    value INT NOT NULL
);

INSERT INTO daily_data (date, value) VALUES (CURDATE(), 100);

SELECT * FROM daily_data WHERE date = '2023-04-01';

DELIMITER $$
CREATE EVENT insert_daily_data
ON SCHEDULE EVERY 1 DAY
DO
BEGIN
    INSERT INTO daily_data (date, value) VALUES (CURDATE(), FLOOR(RAND() * 100));
END$$
DELIMITER ;

CREATE INDEX idx_date ON daily_data(date);

DELIMITER $$
CREATE PROCEDURE fill_missing_dates()
BEGIN
    DECLARE current_date DATE;
    SET current_date = CURDATE();
    WHILE current_date >= '2023-01-01' DO
        IF NOT EXISTS (SELECT 1 FROM daily_data WHERE date = current_date) THEN
            INSERT INTO daily_data (date, value) VALUES (current_date, 0);
        END IF;
        SET current_date = DATE_SUB(current_date, INTERVAL 1 DAY);
    END WHILE;
END$$
DELIMITER ;