mysql 游标创建失败

DELIMITER //

CREATE PROCEDURE cursor_example()
BEGIN
    DECLARE cur CURSOR FOR SELECT * FROM your_table;
    -- 其他逻辑
END //

DELIMITER ;

GRANT EXECUTE ON your_database.* TO 'your_user'@'your_host';

SHOW TABLES LIKE 'your_table';

DELIMITER //

CREATE PROCEDURE cursor_example()
BEGIN
    DECLARE done INT DEFAULT FALSE;
    DECLARE cur CURSOR FOR SELECT * FROM your_table;
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    OPEN cur;

    read_loop: LOOP
        FETCH cur INTO @var1, @var2;
        IF done THEN
            LEAVE read_loop;
        END IF;
        -- 处理数据
    END LOOP;

    CLOSE cur;
END //

DELIMITER ;