递归mysql怎么写_mysql 递归函数写法

递归函数写法

CREATE FUNCTION dgsf (areaId VARCHAR(1000))

RETURNS VARCHAR(4000)

BEGIN

DECLARE sTemp VARCHAR(4000);

DECLARE sTempChd VARCHAR(4000);

SET sTemp = '$';

SET sTempChd = areaId;

WHILE sTempChd is not NULL DO

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

SELECT group_concat(con_parent_unid) INTO sTempChd FROM fcp_uimp_allcontent where FIND_IN_SET(con_unid,sTempChd)>0;

END WHILE;

return sTemp;

END;

调用

select  * from fcp_uimp_allcontent a where   FIND_IN_SET(a.con_unid, dgsf('370,400'))