ORACLE中的for循环怎么转为mysql的for循环
答案:2 悬赏:50 手机版
解决时间 2021-11-24 13:58
- 提问者网友：难遇难求
- 2021-11-23 18:41
ORACLE中的for循环怎么转为mysql的for循环
最佳答案
- 五星知识达人网友：山河有幸埋战骨
- 2021-11-23 20:21
换个写法，mysql里面我也不知道如何用 for in loop来处理。
例如：
CREATE PROCEDURE curdemo()
BEGIN
DECLARE done INT DEFAULT FALSE;
DECLARE a CHAr(16);
DECLARE b, c INT;
DECLARE cur1 CURSOR FOR SELECt id,data FROM test.t1;
DECLARE cur2 CURSOR FOR SELECt i FROM test.t2;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
OPEN cur1;
OPEN cur2;
read_loop: LOOP
FETCH cur1 INTO a, b;
FETCH cur2 INTO c;
IF done THEN
LEAVE read_loop;
END IF;
IF b < c THEN
INSERT INTO test.t3 VALUES (a,b);
ELSE
INSERT INTO test.t3 VALUES (a,c);
END IF;
END LOOP;
CLOSE cur1;
CLOSE cur2;
END;
例如：
CREATE PROCEDURE curdemo()
BEGIN
DECLARE done INT DEFAULT FALSE;
DECLARE a CHAr(16);
DECLARE b, c INT;
DECLARE cur1 CURSOR FOR SELECt id,data FROM test.t1;
DECLARE cur2 CURSOR FOR SELECt i FROM test.t2;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
OPEN cur1;
OPEN cur2;
read_loop: LOOP
FETCH cur1 INTO a, b;
FETCH cur2 INTO c;
IF done THEN
LEAVE read_loop;
END IF;
IF b < c THEN
INSERT INTO test.t3 VALUES (a,b);
ELSE
INSERT INTO test.t3 VALUES (a,c);
END IF;
END LOOP;
CLOSE cur1;
CLOSE cur2;
END;
全部回答
- 1楼网友：蕴藏春秋
- 2021-11-23 20:53
楼主知道了分享哦追问这有那么难回答吗 居然没人知道
我要举报
如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
点此我要举报以上问答信息
大家都在看
推荐资讯