mysql joins：row generation without oracle's connect by

connect by level goase for for row sets in for for for for for for for by for for by low byでは、直接的な同等のものがありません。 Oracleのアプローチは、結合の作成シーケンスの作成を簡素化します：

SELECT *
FROM dual
CONNECT BY LEVEL 

WITH hier(row) AS (
    SELECT 1
    UNION ALL
    SELECT row   1
    FROM hier
    WHERE row 

generate_series ：

SELECT *
FROM generate_series(1, n)