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 ;