文章分类 -  MySQL

MYSQL根据id递归向下查询所有子级【包含该ID】
摘要：SELECT ID.LEVEL, DATA.* FROM ( SELECT @ids AS _ids, ( SELECT @ids := GROUP_CONCAT( id ) FROM 表名 WHERE FIND_IN_SET( 父级 id字段, @ids ) ) AS cids, @l := @l 阅读全文
posted @ 2022-07-13 12:29 #码农9527# 阅读(1061) 评论(0) 推荐(0)