DELIMITER//
CREATE PROCEDURE setRoomManger2()
BEGIN
DECLARE roomids VARCHAR(32);
DECLARE done INT DEFAULT 0;
DECLARE cur CURSOR FOR SELECT roomid FROM nst_t_room;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
OPEN cur;
    FETCH NEXT FROM cur INTO roomids;
REPEAT
    IF NOT done THEN
        INSERT INTO nst_t_devaccess(AccountID,ID,TYPE) VALUES(-1,roomids,1);
    END IF;
    FETCH NEXT FROM cur INTO roomids;
UNTIL done END REPEAT;
CLOSE cur;
END;
CALL setRoomManger2();

 

扫码关注我们
微信号：SRE实战
拒绝背锅 运筹帷幄

SRE实战 互联网时代守护先锋，助力企业售后服务体系运筹帷幄！一键直达领取阿里云限量特价优惠。