mysql 存储过程游标相关

定义本地变量
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;

reeoo.com - web design inspiration

发表回复

您的电子邮箱地址不会被公开。 必填项已用*标注