在mysql lt_<转>mysql 树查询话语

转mysql 树查询语句 原链接：http://skudy.iteye.com/blog/1434254 求下级所有节点 SELECT b.* FROM tree AS a, tree AS b WHERE a.id= b.pid AND(a.id= ? OR a.pi= ?) 求所有子节点 SELECT * FROM tree t WHERE NOT EXISTS( SELECT 1 FROM tree t1, tree t2

mysql 树查询语句

原链接：http://skudy.iteye.com/blog/1434254

求下级所有节点

SELECT

b.*

FROM

tree AS a,

tree AS b

WHERE

a.id= b.pid

AND(a.id= ? OR a.pi= ?)

求所有子节点

SELECT

*

FROM

tree t

WHERE

NOT EXISTS(

SELECT

1

FROM

tree t1,

tree t2

WHERE

t1.id= t2.pid

AND t1.id= t.id

)

求所有根节点

SELECT

*

FROM

tree t

WHERE

NOT EXISTS(

SELECT

1

FROM

tree t1,

tree t2

WHERE

t1.id= t2.pid

AND t1.id= t.pid

)

本文原创发布php中文网，转载请注明出处，感谢您的尊重！