[MariaDB] sql 문으로 VO 만들기 (camel)

SELECT CONCAT(
	 'String ', 
      GROUP_CONCAT(
      CASE WHEN SUBSTR(COLUMN_NAME, SEQ - 1, 1) = '_'
      THEN UPPER(SUBSTR(COLUMN_NAME, SEQ, 1))
      ELSE LOWER(SUBSTR(COLUMN_NAME, SEQ, 1))
      END
      ORDER BY SEQ SEPARATOR '')
    , ';	// ', column_comment) AS CAMELCASE
FROM INFORMATION_SCHEMA.COLUMNS
INNER JOIN seq_1_to_1000 ON SEQ <= LENGTH(COLUMN_NAME)
WHERE TABLE_SCHEMA = '[DB명]'
AND TABLE_NAME = '[테이블명]'
AND SUBSTR(COLUMN_NAME, SEQ, 1) != '_'
GROUP BY TABLE_SCHEMA
 , TABLE_NAME
 , COLUMN_NAME
 , ORDINAL_POSITION
ORDER BY ORDINAL_POSITION

[coulmn -- column_comment]
notice_no -- 공지사항 번호
notice_title -- 공지사항 제목
notice_conts -- 공지사항 내용

[결과]
"String noticeNo; // 공지사항 번호"
"String noticeTitle; // 공지사항 제목"
"String noticeConts; // 공지사항 내용"