mysql 批量更新临时表中的数据

CREATE
    PROCEDURE `301`.`useCursor`()
   
    BEGIN
 
DECLARE msg VARCHAR(255);  


DECLARE STOP INT DEFAULT 0;  
DECLARE cur CURSOR FOR ( SELECT  `诊断` AS msg FROM `生化信息表_copy`  WHERE `诊断` REGEXP '^肝占位');  
  
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET STOP = NULL;   
OPEN cur;  
FETCH NEXT FROM cur INTO msg;  
WHILE ( STOP IS NOT NULL) DO  
UPDATE `生化信息表_copy` SET  `诊断`='肝占位' WHERE `诊断`=msg;  
FETCH NEXT FROM cur INTO msg;  
END WHILE;  
CLOSE cur;  
    END$$


DELIMITER ;