Is there an equivalent of Oracle's
CONNECT BY in MySQL?

help me plz !!
thanks,
srinath

no, there is not

Hi r937,
can i convert this in to Mysql

SELECT y.cnt, date_format(y.date_format, '%M %Y') df FROM (SELECT t.cnt, t.date_format FROM TEST t UNION SELECT 0 cnt,x.datum FROM (SELECT ADD_MONTHS(TRUNC(SYSDATE, 'yyyy'), LEVEL - 1) datum FROM dual CONNECT BY LEVEL <= 12) x WHERE datum NOT IN (SELECT date_format FROM TEST)
AND datum <= (SELECT MAX(date_format) FROM TEST)
) y
ORDER BY y.date_format;