Mysql递归查询

最新推荐文章于 2021-08-25 10:16:19 发布

追逐方向的风

最新推荐文章于 2021-08-25 10:16:19 发布

阅读量469

点赞数

分类专栏： Mysql

本文链接：https://blog.csdn.net/gkqqq/article/details/80281433

版权

Mysql 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

SELECT
IFNULL(CONCAT('[',GROUP_CONCAT(CONCAT('{"catId":"',t.id,'","catName":"',t.name_ch,'","catLevel":',t.level,'}')),']'),"[]") AS companyCategories
FROM
(
SELECT t2.id, t2.name_en,t2.name_ch,t2.level
FROM ( 
    SELECT 
        @r AS _id, 
        (SELECT @r := parent_id FROM c_company_catalog WHERE id = _id) AS parent_id, 
        @l := @l + 1 AS lvl 
    FROM 
        (SELECT @r := 2595, @l := 0) vars, 
        c_company_catalog
    WHERE @r <> 0) t1 
JOIN c_company_catalog t2 
ON t1._id = t2.id 
ORDER BY t1.lvl DESC ) t