mysql 游标 多一行_mysql游标多出一行解决

DELIMITER $$ CREATE     /*[DEFINER = { user | CURRENT_USER }]*/     TRIGGER `pdhmanagementsys`.`tri_devlist_insert` AFTER INSERT     ON dev_list     FOR EACH ROW BEGIN          DECLARE done INT DEFAULT 0;     DECLARE DAttributeName VARCHAR(20);     DECLARE DAttribute_ID INT;     DECLARE DRemark VARCHAR(50);     DECLARE mycursor CURSOR FOR SELECT `Attribute_ID`,`Dev_Attribute`,`Dev_Remark` FROM `device_attribute`  WHERE `Dev_Type` =new.`Dev_Type`;     DECLARE EXIT HANDLER FOR NOT FOUND CLOSE mycursor;  //这里需加 否则会多出一行      OPEN mycursor;           REPEAT     FETCH NEXT FROM mycursor INTO DAttribute_ID,DAttributeName,DRemark;          BEGIN      INSERT INTO `device_value` (`Device_ID`,`RMUID`,`AttributeID`,`Attribute`,`Remark`) VALUES(new.ID,new.`RMU_ID`,DAttribute_ID,DAttributeName,DRemark);      END;       UNTIL 0 END REPEAT; //这里需加 否则会多出一行       CLOSE mycursor;     END$$   DELIMITER ;