56,687
社区成员
发帖
与我相关
我的任务
分享
CREATE procedure `getChildLst`(`rootId` VARCHAR(100)) RETURNS VARCHAR(2000) CHARSET
utf8
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(id) INTO sTempChd FROM hp_node WHERE FIND_IN_SET
(pid,sTempChd)>0;
END WHILE;
RETURN sTemp;
END