Binary Journey

철수 전 기록남기기 2. 테이블정의서 작성 할 때 귀찮으니 모두 뽑기. SELECT TABLE_SCHEMA , TABLE_NAME , COLUMN_NAME , ORDINAL_POSITION , COLUMN_DEFAULT , IS_NULLABLE , DATA_TYPE , COLUMN_TYPE , COLUMN_KEY FROM INFORMATION_SCHEMA.COLUMNS WHERE 1=1 AND TABLE_SCHEMA IN ('스키마명') -- mariaDB의 경우 database 명이라고도 함 ORDER BY TABLE_SCHEMA , TABLE_NAME , ORDINAL_POSITION ;    응용해서 VO, DT..

철수 전 기록 남기기 - 1. SELECT INDEX_SCHEMA , INDEX_NAME , GROUP_CONCAT(COLUMN_NAME ORDER BY SEQ_IN_INDEX) AS INDEX_COLUMNS , INDEX_TYPE , CASE NON_UNIQUE WHEN 1 THEN 'NON_UNIQUE' ELSE 'UNIQUE' END AS IS_UNIQUE , TABLE_NAME FROM INFORMATION_SCHEMA.STATISTICS WHERE TABLE_SCHEMA NOT IN ('INFORMATION_SCHEMA', 'MYSQL', 'PERFORMANCE_SCHEMA', 'SYS') AND INDEX_NAME NOT IN ('PRIMARY') GR..