SHOW SHARDING AUDITORS

Description

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

Syntax

  1. ShowShardingAuditors::=
  2.   'SHOW' '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 for the specified logical database
  1. SHOW SHARDING AUDITORS FROM test1;
  1. mysql> SHOW SHARDING AUDITORS FROM test1;
  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 for the current logical database
  1. SHOW SHARDING AUDITORS;
  1. mysql> SHOW 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, SHARDING, AUDITORS, FROM