定义本地变量
DECLARE idcard varchar(128);
定义游标
DECLARE user_cursor CURSOR FOR
SELECT card_no FROM t_user where last_login_time >= “2013-01-01”;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET no_more_users =1;
SET no_more_users =0;
打开游标
OPEN user_cursor;
循环读取游标的内容
REPEAT
FETCH user_cursor INTO idcard ;
update t_jifen set score=score*1.5 where card_no=@idcard ;
循环结束
UNTIL no_more_users
END REPEAT;
关闭游标
CLOSE user_cursor;