sql 驼峰

SELECT
COLUMN_NAME,
CASE
WHEN LOCATE(‘‘, COLUMN_NAME) = 0 THEN COLUMN_NAME
ELSE
CONCAT(
SUBSTR(COLUMN_NAME, 1, LOCATE(’’, COLUMN_NAME) - 1),
UPPER(SUBSTR(COLUMN_NAME, LOCATE(‘‘, COLUMN_NAME) +1, 1)),
SUBSTR(COLUMN_NAME, LOCATE(’’, COLUMN_NAME) +2)
)
END AS camelCaseColumnName,
SUBSTR(COLUMN_NAME, 1, LOCATE(‘‘, COLUMN_NAME) - 1) AS prf,
UPPER(SUBSTR(COLUMN_NAME, LOCATE(’’, COLUMN_NAME) +1, 1)) AS upp,
SUBSTR(COLUMN_NAME, LOCATE(‘_’, COLUMN_NAME) +2) AS sfx,
column_comment
FROM information_schema.COLUMNS
WHERE TABLE_NAME = ‘t_ci_person’
ORDER BY ORDINAL_POSITION;