Begin
Declare sTemp Varchar(1000);
Declare sTempChd Varchar(1000);
Set sTemp = '$';
Set sTempChd = cast(RootId as Char);
While sTempChd Is Not Null Do
Set sTemp = concat(sTemp,',',sTempChd);
Select group_concat(TypeId) Into sTempChd From Type Where FIND_IN_SET(ParentId,sTempChd);
End While;
Return sTemp;
End
Declare sTemp Varchar(1000);
Declare sTempChd Varchar(1000);
Set sTemp = '$';
Set sTempChd = cast(RootId as Char);
While sTempChd Is Not Null Do
Set sTemp = concat(sTemp,',',sTempChd);
Select group_concat(TypeId) Into sTempChd From Type Where FIND_IN_SET(ParentId,sTempChd);
End While;
Return sTemp;
End