mysql存储过程--重复编号重新赋值

DROP PROCEDURE if EXISTS updateAssetNum;

CREATE PROCEDURE updateAssetNum() 
BEGIN
    DECLARE row_count INT DEFAULT 0;
    DECLARE cur_count int DEFAULT 0;
    DECLARE idStr VARCHAR(256) DEFAULT 'aaa';
    DECLARE idCount INT DEFAULT 0;
    DECLARE idCurCount INT DEFAULT 1;
    DECLARE curId VARCHAR(64) DEFAULT '';
    
    SELECT count(1) coun INTO row_count FROM (SELECT asset_num, GROUP_CONCAT(id) ids,count(asset_num) coun FROM as_asset GROUP BY asset_num) t WHERE t.coun > 1;
    
    SET cur_count = 0;
    WHILE cur_count < row_count DO
        SET idStr = '';
        SELECT ids INTO idStr FROM (SELECT asset_num, GROUP_CONCAT(id) ids,count(asset_num) coun FROM as_asset GROUP BY asset_num) t WHERE t.coun > 1 LIMIT 0,1;
        
        SET cur_count = cur_count + 1;
        IF(IFNULL(LENGTH(idStr),0) > 0) THEN 
            SET idCount = 0;
            SET idCurCount = 1;
            SELECT LENGTH(idStr) - LENGTH(REPLACE(idStr, ',', '')) + 1 INTO idCount;
            WHILE idCurCount <= idCount DO
                set curId = '';
                SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(idStr, ',', idCurCount) , ',' , -1 ) INTO curId;
                IF(LENGTH(curId) > 0) THEN
                    UPDATE as_asset SET asset_num = CONCAT(asset_num,'-',idCurCount) WHERE id = curId;
                    UPDATE as_asset SET manufacturing_num = asset_num,asset_qrcode = asset_num WHERE id = curId;
                END IF;
                SET idCurCount = idCurCount + 1;
            END WHILE;
        END IF;
    END WHILE;
END;