mysql 的递归方法 查询pid为 5246
select ID ,name from (
select t1.ID,t1.PARENTID,name,
if(find_in_set(PARENTID, @pids) > 0, @pids := concat(@pids, ',', ID), 0) as ischild
from (
select t.ID,PARENTID,t.NAME as name from hn_cul...
原创
2021-09-01 15:03:27 ·
416 阅读 ·
0 评论