[ MYSQL ] 컬럼 구조 확인
SELECT TABLE_NAME AS 'table_name', ORDINAL_POSITION AS 'no', COLUMN_NAME AS 'field_name', COLUMN_COMMENT AS 'comment', COLUMN_TYPE AS 'type', COLUMN_KEY AS 'KEY', IS_NULLABLE AS 'NULL', EXTRA AS 'auto', COLUMN_DEFAULT 'default' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = '데이터베이스명' ORDER BY TABLE_NAME, ORDINAL_POSITION; SELECT t1.table_name, t1.table_comment, column_name, data_type, colu..