mysql 테이블 및 컬럼 스키마 정보 뽑기

2017-03-10 10:22:48.0
systemddc
테스트
1549
0

select 
  -- A.TABLE_NAME, 
  B.TABLE_COMMENT,      
  substring(
  replace(
  replace(
  GROUP_CONCAT(DISTINCT  
  CASE
    WHEN  A.COLUMN_KEY = 'PRI' THEN concat('|', A.COLUMN_COMMENT)
    ELSE ''
  END  
  SEPARATOR ','),
  ',', ''), '|', ','), 2, 9999),  
  GROUP_CONCAT(DISTINCT A.COLUMN_COMMENT SEPARATOR ',')  
from INFORMATION_SCHEMA.columns A
LEFT JOIN INFORMATION_SCHEMA.tables B
ON A.TABLE_NAME = B.TABLE_NAME
where A.table_schema = 'xxdb'
group by A.TABLE_NAME