用 Navicat 写mysql的游标

CREATE PROCEDURE pro_users()
begin
         DECLARE myid int;
         DECLARE no int;
         DECLARE mysellerid char(10);    
         DECLARE mylink char(50);    
         DECLARE myip char(50);    
         DECLARE mycursor CURSOR FOR select id from table1; #把select出来的数据全部保存到游标mycursor中
         DECLARE CONTINUE HANDLER FOR NOT FOUND SET no=1; #当读到数据的最后一条时,设置no变量为1
         SET no=0; #初始化变量no为0
         OPEN mycursor; #打开游标
                     while no=0 do #判断是不是到了最后一条数据
                                 fetch mycursor into myid; #读取游标中的数据一一复给变量myid。
                                    select sellerid,link,ip into mysellerid,mylink,myip
                                    from table2 order by RAND() LIMIT 1;
                                    update table1 set 
                                    wangba_uid = ceil(rand()*500),
                                    wangba_sellerid = mysellerid,
                                    wangba_link = mylink,
                                    wangba_ip = myip
                                    where id = myid;
                     end while;
         close mycursor;#最后关闭游标.游标里面存放了那么多数据总是要清理掉的吧。
end

call pro_users()

drop PROCEDURE pro_users

select sellerid,link,ip into mysellerid,mylink,myip from table2 order by RAND() LIMIT 1;

select top 1 mysellerid=sellerid,mylink=link,myip=ip from table2 order by newid();