DROP FUNCTION IF EXISTS myFunction;
CREATE FUNCTION myFunction (rootId INT)
RETURNS varchar(1000)
BEGIN
DECLARE sTemp VARCHAR(1000);
DECLARE sTempChd VARCHAR(1000);
SET sTemp = '';
SET sTempChd =cast(rootId as CHAR);
WHILE sTempChd >1 DO
IF sTemp = ''
THEN
SET sTemp = concat(sTemp,sTempChd);
ELSEIF sTemp <>''
THEN
SET sTemp = concat(sTemp,',',sTempChd);
END IF;
SELECT group_concat(id) INTO sTempChd FROM kkp_panel_page where FIND_IN_SET(aid,sTempChd)>0;
END WHILE;
RETURN sTemp ;
END
存储过程递归查询
最新推荐文章于 2021-12-30 13:20:21 发布