mysql递归方法。

 

 

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一下的所有子节点