[MySql] 메타데이터 획득

메타데이터 획득방법
  SHOW DATABASES;
  SHOW CREATE DATABASE dbname;
  SHOW TABLES;
  SHOW TABLES FROM dbname;
  SHOW CREATE TABLE tblname;
  SHOW TABLE STATUS;
  SHOW TABLE STATUS FROM dbname;
  SHOW COLUMNS FROM tblname;
  SHOW INDEX FROM tblname;

  SHOW TABLES IN INFORMATION_SCHEMA;
  DESCRIBE INFORMATION_SHEMA.CHARACTER_SETS;


직접쳐보고 결과 확인-!