mysql 游标 存储过程操作

DELIMITER $$
drop procedure if exists proc_temp $$

create procedure proc_temp()
  begin
	  DECLARE nLine int ;
    DECLARE countNum int ;
    DECLARE valueM varchar(100);
    DECLARE done INT DEFAULT FALSE;    
    DECLARE cur CURSOR FOR SELECT id FROM basecustomer ;-- 声明游标，以便下面循环  
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET  done = TRUE;-- 将结束标志绑定到游标    

    set countNum = (select count(*) from basecustomer);
    open cur;
    fetch cur into valueM ;

		while nLine <=countNum do
				  set nLine = nLine + 1;
          update basecustomer set id = nLine where KID =valueM  ;
          select valueM;
          fetch cur into valueM ;
    end while;
  end $$

call  proc_temp() $$