mysql数据库相关查询

查询所有表名

• select table_name from information_schema.tables where table_schema='数据库名称';

查询数据库表名的注释:

• select table_name 表名,TABLE_COMMENT 表注释 from INFORMATION_SCHEMA.TABLES Where table_schema = '数据库名称' AND table_name ="表名"

查询所有表名的表注释:

• select table_name 表名,TABLE_COMMENT 表注释 from INFORMATION_SCHEMA.TABLES Where table_schema = '数据库名称' AND table_name IN (select table_name from information_schema.tables where table_schema='数据库名称'); 

查询指定数据的所有表字段 及注释等信息

• SELECT
  a.table_name 表名,
  a.table_comment 表说明,
  b.COLUMN_NAME 字段名,
  b.column_comment 字段说明,
  b.column_type 字段类型,
  b.column_key 约束
  FROM
  information_schema. TABLES a
  LEFT JOIN information_schema.COLUMNS b ON a.table_name = b.TABLE_NAME
  WHERE
  a.table_schema = '数据库名称'
  ORDER BY
  a.table_name;