mysql 存储过程循环

create procedure pName(in a,out b,inout c) 

begin

 declare row_cus_id int;
 declare row_track_Id int;
 


-- 遍历数据结束标志
  DECLARE done INT DEFAULT FALSE;


 declare groupCursor cursor for SELECT id,cus_id from t_ct_cus_track where id in (SELECT MAX(id) FROM t_ct_cus_track GROUP BY cus_id);




  -- 将结束标志绑定到游标
  DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;  


open groupCursor;

 -- 开始循环
  read_loop: LOOP
    -- 提取游标里的数据，这里只有一个，多个的话也一样；
    FETCH groupCursor INTO  row_track_Id,row_cus_id;
    -- 声明结束的时候
    IF done THEN
      LEAVE read_loop;
    END IF;
     
  update t_ct_customer set track_id = row_track_Id where id = row_cus_id;


  END LOOP;


end