错误1064:无法使用变量在mysql中执行while循环

DELIMITER //
CREATE PROCEDURE myProcedure()
BEGIN
    DECLARE i INT DEFAULT 1;
    WHILE i <= 10 DO
        -- 在这里执行你的操作
        SET i = i + 1;
    END WHILE;
END //
DELIMITER ;

DECLARE done INT DEFAULT FALSE;
DECLARE var1 INT;
DECLARE cur CURSOR FOR SELECT column1 FROM table1;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

OPEN cur;
read_loop: LOOP
    FETCH cur INTO var1;
    IF done THEN
        LEAVE read_loop;
    END IF;
    -- 在这里执行你的操作
END LOOP;

CLOSE cur;