CREATE PROCEDURE  questionProc()BEGIN declare pgId int(11);  declare pGuid varchar(255); 　-- 定义游标卡尺 declare done boolean  DEFAULT TRUE; -- 获取数据到游标卡尺 DECLARE cur CURSOR FOR select id,qid from tb_question;-- 打开游标卡尺OPEN cur; 　　-- 开始循环    WHILE done do       FETCH cur INTO pgId,pGuid;                        update tb_question_item set question_id=pgId where qid= pGuid;   end while;CLOSE cur;END;CALL questionProc();