我有一个表格"使用以下数据。
<表类>
pk_id
sk_id
tbody><<tr>1 0 21 3 1 42 53 65 表类>
set @pk_id = 6;
with recursive params as (
select pk_id, sk_id from tabla1 where pk_id = @pk_id
union all
select t.pk_id, t.sk_id
from tabla1 t
join params p
on t.pk_id = p.sk_id)
select pk_id
from params
where pk_id <> @pk_id;
结果:
pk_id|
-----+
5|
3|
1|