你好，我是朱晓峰，下面我就来公布一下上节课思考题的答案： 上节课，我们学习了游标。下面是思考题的答案： DELIMITER // CREATE PROCEDURE demo.myproc() BEGIN DECLARE myid INT; DECLARE myq INT; DECLARE done INT DEFAULT FALSE; DECLARE cursor_test CURSOR FOR SELECT * FROM demo.test; DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE; OPEN cursor_test; FETCH cursor_test INTO myid,myq; REPEAT IF (myid MOD 2 = 0) THEN -- 如果是偶数，加1 UPDATE demo.test SET myquant = myquant + 1 WHERE id = myid; ELSE -- 奇数加2 UPDATE demo.test SET myquant = myquant + 2 WHERE id = myid; END IF; FETCH cursor_test INTO myid,myq; UNTIL done END REPEAT; CLOSE cursor_test; END // DELIMITER ;