mysql procedure cursor

最新推荐文章于 2024-01-15 08:00:00 发布

wangmingming2008

最新推荐文章于 2024-01-15 08:00:00 发布

阅读量185

点赞数

分类专栏： 2013 文章标签： mysql procedure

本文链接：https://blog.csdn.net/wangmingming2008/article/details/84471741

版权

2013 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

SET CHARACTER_SET_CLIENT=utf8;
SET CHARACTER_SET_CONNECTION=utf8;
use tr;
delimiter //
drop procedure if exists blackscreen_reward;

CREATE PROCEDURE blackscreen_reward()
BEGIN
DECLARE uid, tag BIGINT;
DECLARE cur CURSOR FOR select passportId from t_character_info where lastLoginTime >= "2013-08-15 00:00:00";
DECLARE CONTINUE HANDLER FOR NOT FOUND SET tag = 1;
OPEN cur;
SET tag = 0;
WHILE tag = 0 DO
FETCH cur INTO uid;
IF tag = 0 THEN
insert into t_user_prize(coin,createTime,item,passportId,status,type,userPrizeName) values("3=300",now(),"3000290=3",uid,0,4,"title");
END IF;
END WHILE;
CLOSE cur;
END;//
delimiter ;

call blackscreen_reward();
drop procedure if exists blackscreen_reward;