mysql递归tree查询,查找所有的子节点

1.  

2. DROP FUNCTION IF EXISTS queryChildrenAreaInfo;

   CREATE FUNCTION `queryChildrenAreaInfo` (areaId INT)

   RETURNS VARCHAR(4000)

   BEGIN

   DECLARE sTemp VARCHAR(4000);

   DECLARE sTempChd VARCHAR(4000);

    

   SET sTemp = '$';

   SET sTempChd = cast(areaId as char);

    

   WHILE sTempChd is not NULL DO

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

   SELECT group_concat(id) INTO sTempChd FROM t_areainfo where FIND_IN_SET(parentId,sTempChd)>0;

   END WHILE;

   return sTemp;

   END;

3. 2

   --调用方式

   select queryChildrenAreaInfo(1);

   select * from t_areainfo where FIND_IN_SET(id, queryChildrenAreaInfo(1));