mysql 怎么写循环

CREATE TABLE numbers (
    id INT AUTO_INCREMENT PRIMARY KEY,
    num INT
);

DELIMITER //

CREATE PROCEDURE InsertNumbers()
BEGIN
    DECLARE i INT DEFAULT 1;

    WHILE i <= 10 DO
        INSERT INTO numbers (num) VALUES (i);
        SET i = i + 1;
    END WHILE;
END //

DELIMITER ;

CALL InsertNumbers();

SELECT * FROM numbers;

DELIMITER //

CREATE PROCEDURE InsertNumbersUsingRepeat()
BEGIN
    DECLARE i INT DEFAULT 1;

    REPEAT
        INSERT INTO numbers (num) VALUES (i);
        SET i = i + 1;
    UNTIL i > 10 END REPEAT;
END //

DELIMITER ;