mysql查询所有数据库

SELECT
    t.SCHEMA_NAME AS dbName 
FROM
    information_schema.SCHEMATA t

mysql通过数据库名查询表名和注释

SELECT
    t.table_type AS tableType,
    t.TABLE_SCHEMA AS dbName,
    t.table_name AS CODE,
    t.TABLE_COMMENT AS tableName 
FROM
    INFORMATION_SCHEMA.TABLES t 
WHERE
    t.table_type = 'BASE TABLE' 
    AND t.table_schema ='auth_controller'

mysql通过数据库名查询视图名和注释

SELECT
    t.table_type AS tableType,
    t.TABLE_SCHEMA AS dbName,
    t.table_name AS CODE,
    t.TABLE_COMMENT AS tableName 
FROM
    INFORMATION_SCHEMA.TABLES t 
WHERE
    t.table_type = 'VIEW' 
    AND t.table_schema =?

通过数据库和表名查询字段及注释

SELECT
    t.table_schema AS dbName,
    t.TABLE_NAME AS tableCode,
    t.COLUMN_NAME AS fieldCode,
    t.DATA_TYPE AS dataType,
    t.COLUMN_COMMENT AS fieldName 
FROM
    INFORMATION_SCHEMA.COLUMNS t 
WHERE
    t.table_schema =? tAND t.TABLE_NAME =?

mysql查询所有表名和注释

SELECT
    t.TABLE_SCHEMA as dbName,
    t.table_name AS tableCode,
    t.TABLE_COMMENT AS tableName 
FROM
    INFORMATION_SCHEMA.TABLES t