DELIMITER $$
USE `cms`$$
DROP PROCEDURE IF EXISTS `p2`$$
CREATE DEFINER=`root`@`%` PROCEDURE `p2`()
BEGIN
DECLARE result VARCHAR(1280);
DECLARE v_PROGRAM_ID INT;
DECLARE NO INT;
DECLARE cur_1 CURSOR FOR SELECT CONCAT(FINISH_PLATFORM_IDS,';105'),a.PROGRAM_ID FROM a a LEFT JOIN cms_program b ON a.PROGRAM_ID=b.PROGRAM_ID;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET NO=1;
SET NO=0;
OPEN cur_1;
WHILE NO=0 DO
FETCH cur_1 INTO result,v_PROGRAM_ID;
UPDATE cms_program SET FINISH_PLATFORM_IDS=result WHERE PROGRAM_ID=v_PROGRAM_ID;
END WHILE;
CLOSE cur_1;
END$$
DELIMITER ;
USE `cms`$$
DROP PROCEDURE IF EXISTS `p2`$$
CREATE DEFINER=`root`@`%` PROCEDURE `p2`()
BEGIN
DECLARE result VARCHAR(1280);
DECLARE v_PROGRAM_ID INT;
DECLARE NO INT;
DECLARE cur_1 CURSOR FOR SELECT CONCAT(FINISH_PLATFORM_IDS,';105'),a.PROGRAM_ID FROM a a LEFT JOIN cms_program b ON a.PROGRAM_ID=b.PROGRAM_ID;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET NO=1;
SET NO=0;
OPEN cur_1;
WHILE NO=0 DO
FETCH cur_1 INTO result,v_PROGRAM_ID;
UPDATE cms_program SET FINISH_PLATFORM_IDS=result WHERE PROGRAM_ID=v_PROGRAM_ID;
END WHILE;
CLOSE cur_1;
END$$
DELIMITER ;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/30345407/viewspace-2127413/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
查看当前正在执行的sql
下一篇：
生成awr报告的脚本
请登录后发表评论
登录
全部评论
