mysql循环

CREATE DEFINER=`root`@`127.0.0.1` PROCEDURE `dsa_change_status`()
BEGIN
    DECLARE myid INT(11);
    DECLARE i INT DEFAULT 0;
        DECLARE j INT DEFAULT 0;
        DECLARE m VARCHAR(25);

        DECLARE success INT DEFAULT 0;

    DECLARE num INT;
    DECLARE cur CURSOR FOR SELECT clue_id FROM `table` WHERE dealer_id=55;
    SELECT COUNT(*) INTO num FROM `table` WHERE dealer_id=55;
    OPEN cur;
    WHILE i<num DO
    FETCH cur INTO myid;

     SELECT UNIX_TIMESTAMP( CONCAT( '2016/07/' , LPAD(FLOOR(1 + (RAND() * 31)),2,0) ) ) INTO m;
         #SELECT FROM_UNIXTIME(@m,'%Y%m%d') INTO n;

         #80%
         SELECT CASE WHEN FLOOR(1 +(RAND() * 10)) NOT IN (1,2) THEN 1 ELSE 0 END INTO j;
         IF FLOOR(1 +(RAND() * 10)) NOT IN (1,2) THEN
               sql;
         END IF;



    SET i=i+1;
    END WHILE;
    CLOSE cur;

END