mysql不适用存储过程和函数查询所有父级和子级
查询所有父级
SELECT ID.level, targetTable.* FROM(
SELECT
@id as _id,
( SELECT @id := parent_id
FROM `存树形关系的表 `
WHERE id = @id
) as _pid,
@l := @l+1 as level
FROM `存树形关系的表 `,
(SELECT @id := `查询的节点id`...
原创
2019-07-15 17:28:33 ·
504 阅读 ·
0 评论