mysql游标应用

BEGIN
DECLARE a,b,c VARCHAR(32);
DECLARE IS_FOUND INT;
DECLARE cur1 CURSOR FOR 

SELECT id, paper_name,paper_fraction FROM  examination_paper
;

DECLARE CONTINUE HANDLER FOR NOT FOUND SET IS_FOUND=0;
OPEN cur1;
 REPEAT
		
		FETCH cur1 INTO a,b,c;
    update examination_score_info 
		      set paper_name = b,
              paper_fraction = c
          where PAPER_ID = a
;
             
		
 UNTIL IS_FOUND = 0 END REPEAT;
END

说明: 根据现有表字段 批量更新另外一张表的部分字段.