START WITH and CONNECT BY in Oracle SQL

[Pierre Ducrot]

Hi,

Is there any way to write recursive SQL queries in mySQL as it is in Oracle?
See the Oracle example below:

create table test_connect_by (
parent number,
child number,
constraint uq_tcb unique (child)
);

select child
from test_connect_by
start with parent is null
connect by prior child = parent;

Cheers,

Pierre