SHOW DB_DISCOVERY TYPES

Description

The SHOW DB_DISCOVERY TYPES syntax is used to query database discovery types for specified database.

Syntax

Grammar Railroad diagram

  1. ShowDatabaseDiscoveryType::=
  2.   'SHOW' 'DB_DISCOVERY' 'TYPES' ('FROM' databaseName)?
  4. databaseName ::=
  5.   identifier

Supplement

  • When databaseName is not specified, the default is the currently used DATABASE. If DATABASE is not used, No database selected will be prompted.

Return value description

ColumnDescription
nameDatabase discovery type name
typeDatabase discovery type category
propsDatabase discovery type properties

Example

  • Query database discovery types for specified database.
  1. SHOW DB_DISCOVERY TYPES FROM discovery_db;
  1. mysql> SHOW DB_DISCOVERY TYPES FROM discovery_db;
  2. +-------------------+-----------+---------------------------------------------------+
  3. | name              | type      | props                                             |
  4. +-------------------+-----------+---------------------------------------------------+
  5. | group_0_MySQL.MGR | MySQL.MGR | {group-name=667edd3c-02ec-11ea-9bb3-080027e39bd2} |
  6. +-------------------+-----------+---------------------------------------------------+
  7. 1 row in set (0.01 sec)
  • Query database discovery types for current database.
  1. SHOW DB_DISCOVERY TYPES;
  1. mysql> SHOW DB_DISCOVERY TYPES;
  2. +-------------------+-----------+---------------------------------------------------+
  3. | name              | type      | props                                             |
  4. +-------------------+-----------+---------------------------------------------------+
  5. | group_0_MySQL.MGR | MySQL.MGR | {group-name=667edd3c-02ec-11ea-9bb3-080027e39bd2} |
  6. +-------------------+-----------+---------------------------------------------------+
  7. 1 row in set (0.00 sec)

Reserved word

SHOW, DB_DISCOVERY, TYPES, FROM