游标demo

CREATE  PROCEDURE `process_mengbao`()
BEGIN
-- 遍历数据结束标志
DECLARE done INT DEFAULT FALSE;
-- 符合要求的手机号码
DECLARE _mobile CHAR(16);
DECLARE _user_id MEDIUMINT(8);
-- 游标
DECLARE cur CURSOR FOR
  SELECT id,mobile_phone FROM account_user 
  where experience_money = 0 and mobile_phone in 
  (select mobile_phone from tmp_mengbao where tag = 0);
-- 将结束标志绑定到游标
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
-- 打开游标
OPEN cur;

-- 开始循环
read_loop: LOOP
  -- 提取游标里的数据，这里只有一个，多个的话也一样；
  FETCH cur INTO _user_id, _mobile;
  -- 声明结束的时候
  IF done THEN
    LEAVE read_loop;
  END IF;
  -- 更新用户信息

  update account_user bla bla bla
END LOOP;
-- 关闭游标
CLOSE cur;
END