DROP FUNCTION IF EXISTS getParentList;
CREATE FUNCTION `getParentList` (pkFolder VARCHAR(100)) RETURNS VARCHAR (1000)
BEGIN
DECLARE
fid VARCHAR (100) DEFAULT '';
DECLARE
str VARCHAR (2000) DEFAULT pkFolder;
WHILE pkFolder IS NOT NULL DO
SET fid = (
SELECT
pk_parent_folder
FROM
intercl_folder
WHERE
pk_folder = pkFolder
);
IF fid IS NOT NULL THEN
SET str = concat(str, ',', fid);
SET pkFolder = fid;
ELSE
SET pkFolder = fid;
END IF;
END WHILE;
RETUR
mysql自定义函数实现递归查询
最新推荐文章于 2023-11-20 14:32:04 发布