mysql 层次查询 MySQL中进行树状所有子节点的查询

1，先建函数

2，用语句查询

 

第一步

 

CREATE FUNCTION `getChildLst` (rootId INT) //注意红色的单引号
     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(id) INTO sTempChd FROM sinykk_url_sort where FIND_IN_SET(parent_id ,sTempChd)>0;
       END WHILE;
       RETURN sTemp;
     END

 

第二步

select * from sinykk_url_sort where FIND_IN_SET(id, getChildLst(1273));