本文共 814 字，大约阅读时间需要 2 分钟。

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; CREATE FUNCTION `getGoodsChildLst` (rootId char(32)) RETURNS varchar(1000) 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(cateID) INTO sTempChd     FROM goodscategory     WHERE FIND_IN_SET(parentCateID, sTempChd) > 0;   END WHILE;   RETURN sTemp; END

转载地址：https://blog.csdn.net/wll_1017/article/details/44982523 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！