SHOW UNUSED SHARDING AUDITORS
Description
SHOW SHARDING AUDITORS syntax is used to query sharding auditors that are not used in specified database.
Syntax
ShowUnusedShardingAuditors::=
'SHOW' 'UNUSED' 'SHARDING' 'AUDITOR' ('FROM' databaseName)?
databaseName ::=
identifierSupplement
- 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
| column | Description |
|---|---|
| name | Sharding auditor name |
| type | Sharding auditor algorithm type |
| props | Sharding auditor algorithm properties |
Example
- Query sharding auditors that are not used in the specified logical database
SHOW UNUSED SHARDING AUDITORS FROM sharding_db;mysql> SHOW UNUSED SHARDING AUDITORS FROM sharding_db;
+-------------------------------+-------------------------+-------+
| name | type | props |
+-------------------------------+-------------------------+-------+
| sharding_key_required_auditor | dml_sharding_conditions | |
+-------------------------------+-------------------------+-------+
1 row in set (0.01 sec)- Query sharding auditors are not used in the current logical database
SHOW UNUSED SHARDING AUDITORS;mysql> SHOW UNUSED SHARDING AUDITORS;
+-------------------------------+-------------------------+-------+
| name | type | props |
+-------------------------------+-------------------------+-------+
| sharding_key_required_auditor | dml_sharding_conditions | |
+-------------------------------+-------------------------+-------+
1 row in set (0.00 sec)Reserved word
SHOW, UNUSED, SHARDING, AUDITORS, FROM