?

?

DROP FUNCTION IF EXISTS `getChildLst`;

?

CREATE DEFINER = `root`@`%` FUNCTION `getChildLst`(rootId INT)

?RETURNS varchar(1000)

BEGIN?

DECLARE sTemp VARCHAR(3000);

DECLARE sTempChd VARCHAR(3000);

SET sTemp = "-1";

SET sTempChd =cast(rootId as CHAR);

WHILE sTempChd is not null DO

SET sTemp = concat(sTemp,',',sTempChd);

SELECT GROUP_CONCAT(g.groupid) INTO sTempChd FROM wcmgroup g where FIND_IN_SET(g.parentid, sTempChd)>0;

END WHILE;

RETURN sTemp;

END;

?

?

通过rootid遍历rootid一下的所有子节点