mysql - 将Oracle PL/SQL转换为Mysql

如何转换以下结构：

for i in (select distinct rr.date_ as dater
          from REGULATORYR rr, country c
          where rr.date_>=datedebut
          and rr.date_<= datefin
           and c.pk_=rr.countrypk_
            and c.name_= pays
            order by rr.date_ )
loop

最佳答案

这应该是关于您的问题的答案：

declare i cursor for select distinct rr.date_ as dater
          from REGULATORYR rr, country c
          where rr.date_>=datedebut
          and rr.date_<= datefin
           and c.pk_=rr.countrypk_
            and c.name_= pays
            order by rr.date_;
open i;
fetch i into;
while not_found=0
do

关于mysql - 将Oracle PL/SQL转换为Mysql，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/55791328/