mysql低版本递归查询

最新推荐文章于 2024-09-14 19:55:29 发布

SednaLin

最新推荐文章于 2024-09-14 19:55:29 发布

阅读量124

点赞数 3

文章标签：数据库

本文链接：https://blog.csdn.net/qq_30125403/article/details/140155233

版权

上级往下级递归

SELECT user_id FROM ( 
	SELECT @cids AS child_ids, (SELECT @cids := GROUP_CONCAT(user_id) FROM wtl_admin_user WHERE FIND_IN_SET(parent_id,@cids) ) AS cids 
	FROM wtl_admin_user,
	(SELECT @cids := 19938 ) b WHERE @cids <> '0' 
) T1, wtl_admin_user T2 
WHERE FIND_IN_SET(T2.user_id,T1.child_ids)

下级往上级递归

SELECT user_id FROM ( 
	SELECT 
		@cids AS parent_ids, 
		(SELECT @cids := GROUP_CONCAT(user_id) FROM wtl_admin_user WHERE user_id = (SELECT parent_id FROM wtl_admin_user WHERE user_id = @cids) ) AS cids 
	FROM wtl_admin_user,
	(SELECT @cids := 19887 ) b WHERE @cids is not null AND @cids <> '0' 
) T1, wtl_admin_user T2 
WHERE T2.user_id = T1.parent_ids