SHOW UNUSED SHARDING AUDITORS

Description

SHOW SHARDING AUDITORS syntax is used to query sharding auditors that are not used in specified database.

Syntax

Grammar Railroad diagram

  1. ShowUnusedShardingAuditors::=
  2.   'SHOW' 'UNUSED' 'SHARDING' 'AUDITOR' ('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
nameSharding auditor name
typeSharding auditor algorithm type
propsSharding auditor algorithm properties

Example

  • Query sharding auditors that are not used in the specified logical database
  1. SHOW UNUSED SHARDING AUDITORS FROM sharding_db;
  1. mysql> SHOW UNUSED SHARDING AUDITORS FROM sharding_db;
  2. +-------------------------------+-------------------------+-------+
  3. | name                          | type                    | props |
  4. +-------------------------------+-------------------------+-------+
  5. | sharding_key_required_auditor | dml_sharding_conditions | {}    |
  6. +-------------------------------+-------------------------+-------+
  7. 1 row in set (0.01 sec)
  • Query sharding auditors are not used in the current logical database
  1. SHOW UNUSED SHARDING AUDITORS;
  1. mysql> SHOW UNUSED SHARDING AUDITORS;
  2. +-------------------------------+-------------------------+-------+
  3. | name                          | type                    | props |
  4. +-------------------------------+-------------------------+-------+
  5. | sharding_key_required_auditor | dml_sharding_conditions | {}    |
  6. +-------------------------------+-------------------------+-------+
  7. 1 row in set (0.00 sec)

Reserved word

SHOW, UNUSED, SHARDING, AUDITORS, FROM