Re: Create view with MySQL 4.1.20

[tanja]

Hello Nick,
it is so. I have a table, where I look for the depth of the dependency between e.g. child_id and parent_id.

child_id parent_id
----------------------
1 0
2 0
3 1
4 3
.....

So here is the depth 3.

I can do this with recursive query by view.
For example:
with recursive ChildInDirect (child_id ) as
(select child_id
from mytable
where parent_id = 0
union
select mytable.child_id
from childIdDirect, mytable
where mytable.parent_id = ChildInDirect.child_id)

It is my view with recursive query, and this query runs so long, untill I don't have anymore dependencies.
then I can do

select count(child_id)
fromChildInDirect;

Therefore I asked, how I can use view with MySQL.
Thank you!
Tanja