ORACLE中的for循环怎么转为mysql的for循环

Question

BEGIN
FOR v_hk IN (
select *
from (select t1.TRADECODE,
t1.SNAME,
(select hkcomcode from qdata.t_pub010 where tradecode = t1.TRADECODE and f005 = '2' and f004 in ('2', '5') and rownum < 2) as hkcomcode,
(select f001 from qdata.t_ref020 where f002 = t1.sname and length(f001) >= 8) as f001
from (select TRADECODE, SNAME from lein.t_hk_com001_lein) t1)
where length(f001) >= 8

) LOOP

update qdata.t_hk_com001 set f010 = v_hk.f001 where qdata.t_hk_com001.comcode = v_hk.hkcomcode;

END LOOP;
commit;

END;
这是oracle的for循环 现在想转为mysql的for循环 怎么写？
也可以用v_hk别名吗？

Answer 1

换个写法，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;

Answer 2

楼主知道了分享哦

追问

这有那么难回答吗 居然没人知道