MySql, MariaDB에서 connect by level 구현하기

-- ORACLE
SELECT LEVEL
  FROM DUAL
  CONNECT BY LEVEL <= 8

-- 결과
-- LEVEL
-- 1
-- 2
-- 3
-- 4
-- 5
-- 6
-- 7
-- 8

-- MySQL, mariaDB
WITH RECURSIVE A AS (
    SELECT 1 AS LEVEL
    UNION ALL
    SELECT 1+A.LEVEL
      FROM A
     WHERE A.LEVEL <8
     )
SELECT LEVEL
  FROM A

출처: https://aljjabaegi.tistory.com/549 [알짜배기 프로그래머:티스토리]