SHOW UNUSED SHARDING ALGORITHMS
Description
The SHOW UNUSED SHARDING ALGORITHMS syntax is used to query the unused sharding algorithms in the specified database.
Syntax
ShowShardingAlgorithms::=
'SHOW' 'UNUSED' 'SHARDING' 'ALGORITHMS' ('FROM' databaseName)?
databaseName ::=
identifierSupplement
- When
databaseNameis not specified, the default is the currently usedDATABASE. IfDATABASEis not used,No database selectedwill be prompted.
Return value description
| Column | Description |
|---|---|
| name | Sharding algorithm name |
| type | Sharding algorithm type |
| props | Sharding algorithm properties |
Example
- Query the unused sharding table algorithms of the specified logical database
SHOW UNUSED SHARDING ALGORITHMS;mysql> SHOW UNUSED SHARDING ALGORITHMS;
+---------------+--------+-----------------------------------------------------+
| name | type | props |
+---------------+--------+-----------------------------------------------------+
| t1_inline | INLINE | algorithm-expression=t_order_${order_id % 2} |
+---------------+--------+-----------------------------------------------------+
1 row in set (0.01 sec)Reserved word
SHOW, UNUSED, SHARDING, ALGORITHMS, FROM