游标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 blaEND LOOP;-- 关闭游标CLOSE cur;END