DB (2) 썸네일형 리스트형 [MariaDB] 컬럼명 카멜 케이스로 출력하기 스네이크 케이스(Snake Case) 컬럼명을 카멜 케이스(Camel Case)로 출력하기WITH TB AS (SELECT COLUMN_NAME , SUBSTRING_INDEX(SUBSTRING_INDEX(TB.COLUMN_NAME, '_', NUMBERS.N), '_', -1) AS NAME , CONCAT('/* ', COLUMN_COMMENT, ' */') AS COLUMN_COMMENT , N FROM (SELECT 1 AS N UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5) AS NUMBERS INNER JOIN INFORMATIO.. MariaDB - 달력(Calendar) 출력하기 (날짜 주 단위로 출력) 2024년 5월( 2024-05-01 ~ 2024-05-31 ) 날짜 출력WITH RECURSIVE DATE_TEMP AS ( SELECT DATE_FORMAT('2024-05-01', '%Y%m%d') AS DT , WEEKDAY('2024-05-01') AS WEEKDAY , WEEK('2024-05-01') AS WEEK UNION ALL SELECT DATE_FORMAT(DATE_ADD(DATE_TEMP.DT, INTERVAL 1 DAY), '%Y%m%d') AS DT , WEEKDAY(DATE_ADD(DATE_TEMP.DT, INTERVAL 1 DAY)) AS WEEKDAY , WEEK(DATE_ADD(DATE_TEMP.DT, INTERVAL 1 DAY)) AS WEEK FR.. 이전 1 다음
