怎么递归调用mysql

with a as

(select * from table1 where parentid=0

union all

select b.* from a,table1 b where a.id=b.parentid)

select * from a

用with as 来实现递归

概念说不一定理解，给你一个例子你自己参悟。 SELECT TEACHER FROM C AS X WHERE UNIQUE(SELECT TEACHER FROM C AS Y WHERE Y.TEACHER=X.TEACHER)

---