例1：
create procedure proce_cursor_demo()
BEGIN
    -- 声明变量
    declare o int;
    -- 声明游标
    declare cur_user CURSOR
    FOR
    select age from `user`;
    OPEN cur_user;
    FETCH cur_user INTO o;
    CLOSE cur_user;

END

create procedure proce_cursor_demo2()
BEGIN
    -- 声明变量 
    declare done boolean default 0;
    declare i int;
    declare a int;

    -- 声明游标
    declare cur_get_age_for_id CURSOR
    FOR
    SELECT id FROM `user`;

    -- 声明句柄
    declare continue handler  for SQLSTATE '02000' set done = 1;

    -- 创建用来保存id和age的表
    create table if not exists u_age
        (uid int,age int);
        
    -- open the curson
    OPEN cur_get_age_for_id;
    
    -- 遍历所有行
    REPEAT
        -- 得到id
        FETCH cur_get_age_for_id INTO i;
        -- 调用外部存储过程 得到age
        CALL proce_age_for_id(i,0,a);
        -- 插入到u_age表
        insert into u_age(uid,age) VALUES (i,a);
    
    -- 结束遍历
    UNTIL done END REPEAT;

    -- close the curson
    CLOSE cur_get_age_for_id;
    
END;

-- 执行函数
CALL proce_cursor_demo2();