- BEGIN
- /**
- *
- * 游标模版
- * @author xuyw
- * @email [email protected]
- * @date 2014-05-19
- */
- /*游标数据变量 uid*/
- DECLARE uid VARCHAR(128);
- DECLARE done INT DEFAULT 0;
- /*查询所有用户*/
- DECLARE cur CURSOR FOR SELECT xxx FROM xx;
- DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
- OPEN cur;
- /* 开始循环*/
- REPEAT
- /* 提取游标里的数据*/
- FETCH cur INTO uid;
- IF done =0 THEN
- 执行你的业务
- END IF;
- UNTIL done=1
- END REPEAT;
- /*关闭游标*/
- CLOSE cur;
- END;
来源: http://www.phpxs.com/code/1005307/