SHOW SHARDING ALGORITHMS
Description
The SHOW SHARDING ALGORITHMS syntax is used to query the sharding algorithms in the specified database.
Syntax
ShowShardingAlgorithms::=
'SHOW' '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 sharding algorithms of the specified logical database
SHOW SHARDING ALGORITHMS FROM sharding_db;mysql> SHOW SHARDING ALGORITHMS FROM sharding_db;
+-------------------------+--------+-----------------------------------------------------+
| name | type | props |
+-------------------------+--------+-----------------------------------------------------+
| t_order_inline | INLINE | algorithm-expression=t_order_${order_id % 2} |
| t_order_item_inline | INLINE | algorithm-expression=t_order_item_${order_id % 2} |
+-------------------------+--------+-----------------------------------------------------+
2 rows in set (0.01 sec)- Query the sharding algorithms of the current logical database
SHOW SHARDING ALGORITHMS;mysql> SHOW SHARDING ALGORITHMS;
+-------------------------+--------+-----------------------------------------------------+
| name | type | props |
+-------------------------+--------+-----------------------------------------------------+
| t_order_inline | INLINE | algorithm-expression=t_order_${order_id % 2} |
| t_order_item_inline | INLINE | algorithm-expression=t_order_item_${order_id % 2} |
+-------------------------+--------+-----------------------------------------------------+
2 rows in set (0.01 sec)Reserved word
SHOW, SHARDING, ALGORITHMS, FROM