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));

 

源文档 <http://sinykk.iteye.com/blog/837693>