mysql游标实例

 use industry_finance;
DELIMITER //
 drop procedure if exists  useCursor //   
 CREATE PROCEDURE useCursor()
    BEGIN
         declare id varchar(20) default '' ;
         declare i   int ;
         declare nub   int ;
         declare tid_ varchar(20) default '' ;
         declare CODE_ varchar(50) default '' ;
         declare NAME_ varchar(50) default '' ;
         declare cur1 CURSOR FOR SELECT ID_ FROM t_industry_finance_instance;
        SELECT count(*)+1  into nub FROM companyinfo ;
         set i=1;
     OPEN cur1;
         FETCH cur1 INTO id;
      WHILE (id is not null ) DO
  SELECT id_  into  tid_  FROM companyinfo where ID_=i;
  SELECT ARTIFICIAL_PERSON_CODE_  into CODE_  FROM companyinfo where id_=i;
  SELECT COMPANY_NAME_  into NAME_  FROM companyinfo where id_=i;
 update t_industry_finance_instance  set  ent_id_=tid_,ARTIFICIAL_PERSON_CODE_=CODE_  ,

COMPANY_NAME_= NAME_ where ID_=id;
set i=i+1;
if(i>nub) THEN  set i=1; END IF;
  FETCH cur1 INTO id;
      END WHILE;           
    CLOSE cur1;
END;//
DELIMITER ;
call useCursor();