The SHOW DB_DISCOVERY TYPES
syntax is used to query database discovery types for specified database.
ShowDatabaseDiscoveryType::=
'SHOW' 'DB_DISCOVERY' 'TYPES' ('FROM' databaseName)?
databaseName ::=
identifier
databaseName
is not specified, the default is the currently used DATABASE
. If DATABASE
is not used, No database selected
will be prompted.Column | Description |
---|---|
name | Database discovery type name |
type | Database discovery type category |
props | Database discovery type properties |
SHOW DB_DISCOVERY TYPES FROM discovery_db;
mysql> SHOW DB_DISCOVERY TYPES FROM discovery_db;
+-------------------+-----------+---------------------------------------------------+
| name | type | props |
+-------------------+-----------+---------------------------------------------------+
| group_0_MySQL.MGR | MySQL.MGR | {group-name=667edd3c-02ec-11ea-9bb3-080027e39bd2} |
+-------------------+-----------+---------------------------------------------------+
1 row in set (0.01 sec)
SHOW DB_DISCOVERY TYPES;
mysql> SHOW DB_DISCOVERY TYPES;
+-------------------+-----------+---------------------------------------------------+
| name | type | props |
+-------------------+-----------+---------------------------------------------------+
| group_0_MySQL.MGR | MySQL.MGR | {group-name=667edd3c-02ec-11ea-9bb3-080027e39bd2} |
+-------------------+-----------+---------------------------------------------------+
1 row in set (0.00 sec)
SHOW
, DB_DISCOVERY
, TYPES
, FROM