mysql里面循环语句怎么写

DELIMITER //

CREATE PROCEDURE simple_while_loop()
BEGIN
    DECLARE counter INT DEFAULT 1;

    WHILE counter <= 5 DO
        SELECT counter;
        SET counter = counter + 1;
    END WHILE;
END //

DELIMITER ;

CALL simple_while_loop();

DELIMITER //

CREATE PROCEDURE simple_repeat_loop()
BEGIN
    DECLARE counter INT DEFAULT 1;

    REPEAT
        SELECT counter;
        SET counter = counter + 1;
    UNTIL counter > 5 END REPEAT;
END //

DELIMITER ;

CALL simple_repeat_loop();

DELIMITER //

CREATE PROCEDURE simple_loop()
BEGIN
    DECLARE counter INT DEFAULT 1;

    loop_label: LOOP
        SELECT counter;
        SET counter = counter + 1;

        IF counter > 5 THEN
            LEAVE loop_label;
        END IF;
    END LOOP;
END //

DELIMITER ;

CALL simple_loop();

DELIMITER //

CREATE PROCEDURE insert_dates(start_date DATE, end_date DATE)
BEGIN
    DECLARE current_date DATE DEFAULT start_date;

    WHILE current_date <= end_date DO
        INSERT INTO dates_table (date_column) VALUES (current_date);
        SET current_date = DATE_ADD(current_date, INTERVAL 1 DAY);
    END WHILE;
END //

DELIMITER ;

CALL insert_dates('2023-01-01', '2023-01-05');