CREATE DEFINER=`root`@`localhost` PROCEDURE `sos`( )

 BEGIN

 -- 创建一个临时表

     DROP TABLE IF EXISTS fids_temp;

   CREATE temporary TABLE IF NOT EXISTS fids_temp(

         fid VARCHAR (64),

         deviceIds VARCHAR(64)

     ) ;

     BEGIN

     -- 声明游标

     declare a VARCHAR(64);

     declare b VARCHAR(64);

     -- 声明在最后一行标记

     DECLARE flag int DEFAULT 0;

     -- 声明一个多个结果集

     DECLARE fids_deviceId CURSOR FOR SELECT fid,device_id FROM device_fids_copy WHERE `status`= 'ENABLE' AND  device_id like 'A12601A%' LIMIT 0,50 ;

     -- 设置结束标识

     DECLARE CONTINUE HANDLER FOR SQLSTATE '' SET flag = 1;

     -- 打开游标

     open fids_deviceId;

       -- 读取游标第一行

             FETCH fids_deviceId into a,b;

             WHILE flag<> 1 DO

                 -- 插入临时表

                 INSERT into fids_temp (fid,deviceIds) VALUES (a,b);

                 -- 读取下一行

                 FETCH fids_deviceId into a,b;

             END WHILE;

 --  有开就有关

     close fids_deviceId;

     SELECT * FROM fids_temp;

     -- SELECT COUNT(*) FROM fids_temp;

     end;

 END