MySql递归查询

最新推荐文章于 2024-05-22 16:29:40 发布

ldh_lyf

最新推荐文章于 2024-05-22 16:29:40 发布

阅读量218

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/lyf_ldh/article/details/81086209

版权

数据库专栏收录该内容

39 篇文章 0 订阅

订阅专栏

CREATE DEFINER=`ip`@`%` FUNCTION `getParentList`(rootId INT) RETURNS varchar(1000) CHARSET utf8
BEGIN
	DECLARE sParentList VARCHAR (1000);
	DECLARE sParentTemp VARCHAR (1000);
	SET sParentTemp = cast(rootId AS CHAR);
	WHILE sParentTemp IS NOT NULL DO
		IF (sParentList IS NOT NULL) THEN
			SET sParentList = concat(
				sParentTemp,
				',',
				sParentList
				);
			ELSE
				SET sParentList = concat(sParentTemp);
			END
		 IF;
##group_concat([DISTINCT] 要连接的字段 [Order BY ASC/DESC 排序字段] [Separator '分隔符'])
		SELECT group_concat(pid) INTO sParentTemp FROM bas_basic_tree WHERE FIND_IN_SET(id, sParentTemp) > 0;
	END
	WHILE;
	RETURN sParentList;
END