INSERT INTO goods.spr_type (id_parent, order_, name)
      VALUES (id_parent, 0, name_);
    SET @id = LAST_INSERT_ID();
    SET @p = REPLACE(list, '#', @id);
   
   
      UPDATE  spr_type, (SELECT 
          id,
          FIND_IN_SET(id, @p) AS d
        FROM spr_type
        WHERE id_parent = 0
        ORDER BY d) AS cte
      SET spr_type.order_ = cte.d
      WHERE spr_type.id = cte.id;
 

INSERT INTO goods.spr_type (id_parent, order_, name)
      VALUES (id_parent, 0, name_);
    SET @id = LAST_INSERT_ID();
    SET @p = REPLACE(list, '#', @id);

call proc(@p);

    INSERT LOW_PRIORITY INTO goods.spr_type (id_parent, order_, name)
      VALUES (id_parent, 0, name_);
    SET @id = LAST_INSERT_ID();
    SET @p = REPLACE(list, '#', @id);

    CALL proc(@p);
    -- 
    --       UPDATE  spr_type, (SELECT 
    --           id,
    --           FIND_IN_SET(id, @p) AS d
    --         FROM spr_type
    --         WHERE id_parent = 0
    --         ORDER BY d ) AS cte
    --       SET spr_type.order_ = cte.d
    --       WHERE spr_type.id = cte.id;
    -- 

    SELECT  @id,   0 AS d
    UNION ALL
    SELECT  @p,    0 AS d
    UNION ALL
    SELECT  id,    1 AS d
    --           FIND_IN_SET(id, @p) AS d
    FROM spr_type
    WHERE id_parent = 0
    ORDER BY d
    ;

52    0 
38,52,39,1,4    0 
39    1 
39    1 
39    1 
39    1 
39    1 
39    1 
39    1 
39    1 
39    1 
39    1 
39    1 
 

INSERT LOW_PRIORITY INTO goods.spr_type (id_parent, order_, name)
      VALUES (id_parent, 0, name_);


 SET @q=0;
    SELECT
      id,   @q:=@q+1 AS q
    FROM spr_type
    WHERE id_parent = 0

59    1 
59    2 
59    3 
59    4 
59    5 
59    6 
59    7 
59    8 
59    9 
59    10 
59    11 
59    12 
59    13 

Create table/tablespace 'spr_type' failed, as disk is full