SELECT
ORDINAL_POSITION AS '필드순번',
COLUMN_NAME AS '필드명',
COLUMN_KEY AS 'KEY',
DATA_TYPE AS '데이터 TYPE',
COLUMN_TYPE AS '데이터 LENGTH',
IS_NULLABLE AS 'NULL값여부',
#EXTRA AS '자동여부',
#COLUMN_DEFAULT AS '디폴트값',
COLUMN_COMMENT AS '필드설명'
FROM INFORMATION_SCHEMA.COLUMNS
WHERE
#TABLE_SCHEMA = '스키마명'
TABLE_NAME = 'mobile_version'
ORDER BY TABLE_NAME, ORDINAL_POSITION;