mysql 테이블 컬럼 정의 쿼리

전체

SELECT
    a.TABLE_NAME '테이블명',
    b.ORDINAL_POSITION '순번',
    b.COLUMN_NAME '필드명',
    b.DATA_TYPE 'DATA TYPE',
    b.COLUMN_TYPE '데이터길이',
    b.COLUMN_KEY 'KEY',
    b.IS_NULLABLE 'NULL값여부',
    b.EXTRA '자동여부',
    b.COLUMN_DEFAULT '디폴트값',
    b.COLUMN_COMMENT '필드설명'
from information_schema.TABLES a join information_schema.COLUMNS b 
    on a.TABLE_NAME = b.TABLE_NAME 
    and a.TABLE_SCHEMA = b.TABLE_SCHEMA
WHERE 1=1
AND a.TABLE_SCHEMA = 'DATABASE NAME'
ORDER BY a.TABLE_NAME, b.ORDINAL_POSITION

개별

SELECT
    A.ORDINAL_POSITION AS '순번',
    A.COLUMN_NAME AS '필드명',
    A.DATA_TYPE AS 'DATA TYPE',
    A.COLUMN_TYPE AS '데이터길이',
    A.COLUMN_KEY AS 'KEY',
    A.IS_NULLABLE  AS 'NULL값여부',
    A.EXTRA AS '자동여부',
    A.COLUMN_DEFAULT AS '디폴트값',
    A.COLUMN_COMMENT AS '필드설명'
FROM information_schema.COLUMNS A
WHERE 1=1
AND TABLE_SCHEMA = 'DATABASE NAME' 
AND TABLE_NAME = 'TABLE NAME'
ORDER BY TABLE_NAME, ORDINAL_POSITION