SOOM_BLOG [숨숨 블로그]

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

TIL/db

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

soomst 2022. 10. 4. 17:16 
-- 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 [알짜배기 프로그래머:티스토리]

'TIL > db' 카테고리의 다른 글

MySQL) date_format  (1) 2022.10.04
MySQL) MIN, MAX 값 구하기  (0) 2022.10.04
'TIL/db' Related Articles more