如何将postgresql的递归语句用mysql实现
postgresql中可以通过with recursive 实现递归查询,但是mysql好像不能支持,有么有那个兄弟帮忙看看解决,感激不尽哈。 WITH RECURSIVE d AS (SELECT d1.id,d1.pid,d1.name,d1.sort_num,d1.type FROM v_user_position d1 WHERE d1.id=?
UNION ALL SELECT d2.id,d2.pid,d2.name,d2.sort_num,d2.type FROM v_user_position d2, d WHERE d2.pid = d.id)
SELECT DISTINCT id FROM d WHERE TYPE=10 AND d.id NOT IN (SELECT id FROM sso_user WHERE position_id =? AND id!=?)