mysql 游標使用模版

BEGIN?  ???/**??  ?????*???  ?????*?游標模版??  ?????*?@author?xuyw??  ?????*?@email?xyw10000@163.com??  ?????*?@date?2014-05-19??  ?????*/??  ?????/*游標數據變量?uid*/??  ????DECLARE?uid?VARCHAR(128);??  ????DECLARE?done?INT?DEFAULT?0;??  ???????  ????/*查詢所有用戶*/??  ????DECLARE?cur?CURSOR?FOR?SELECT?xxx?FROM?xx;??  ????DECLARE?continue?HANDLER?FOR?NOT?FOUND?SET?done?=?1;??  ??OPEN?cur;??  ????/*?開始循環*/??  ????REPEAT??  ????/*?提取游標里的數據*/??  ????FETCH?cur?INTO?uid;??  ????IF?done?=0?THEN??  ????執行你的業務??  ???END?IF;??  ??UNTIL?done=1??  ??END?REPEAT;??  ??/*關閉游標*/??  ??CLOSE?cur;??  END;