mysql树形查询示例

如下：detailIndustryId是mysql函数的参数，一旦上级行业的id等于1则递归中断

BEGIN

DECLARE sTempId INT;

DECLARE sParentIndustryId INT;

 

SET sTempId=detailIndustryId;

SET sParentIndustryId = 0;

 

 

SELECT `上级行业` INTO sParentIndustryId FROM `行业` WHERE id = detailIndustryId;

WHILE sParentIndustryId <> 1 DO

SET sTempId = sParentIndustryId;

SELECT `上级行业` INTO sParentIndustryId FROM `行业` WHERE id = sTempId;

END WHILE;

RETURN sTempId;

 

END