关于oracle语句转换为mysql的语句 主要是rownum不会转换

declare
cursor c1 is
with
a as(
select rownum rn1,a from t3),
b as(
select rownum rn2,b from t3),
c as(
select rownum rn3,c from t3),
d as(
select rownum rn4,d from t3),
e as(
select rownum rn5,e from t3),
f as(
select rownum rn6,f from t3),
g as(
select rownum rn7,g from t3)
select * from a,b,c,d,e,f,g;
x int;
begin
for i in c1 loop
select count(m) into x
from (
select i.rn1 m from dual
union
select i.rn2 from dual
union
select i.rn3 from dual
union
select i.rn4 from dual
union
select i.rn5 from dual
union
select i.rn6 from dual
union
select i.rn7 from dual
);
if
x/7>0.5 then
insert into t4 values(i.a,i.b,i.c,i.d,i.e,i.f,i.g);
commit;
end if;
end loop;
end;
/

就是这个游标 怎么在mysql中试线这个游标的功能
试着调了半天 rownum这个不知道怎么解决 大哥大嫂来看下怎么弄吧
这个是表t3的表结构 t4 跟它是一样的

select rownum rn1
换成
select @rownum1=@rownum1+1 as rn1

别的类似

来个大哥帮帮忙吧 转换之后好用我可以再加20