SHOW DB_DISCOVERY TYPES

Description

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

Syntax

  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 test1;
  1. mysql> SHOW DB_DISCOVERY TYPES FROM test1;
  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