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
ShowUnusedShardingAuditors::=
'SHOW' 'UNUSED' 'SHARDING' 'AUDITOR' ('FROM' databaseName)?
databaseName ::=
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
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
Related links
当前内容版权归 ShardingSphere 或其关联方所有,如需对内容或内容相关联开源项目进行关注与资助,请访问 ShardingSphere .