SHOW SHARDING TABLE NODES
Description
SHOW SHARDING TABLE NODES syntax is used to query sharding table nodes in specified database.
Syntax
ShowShardingTableNodes::=
'SHOW' 'SHARDING' 'TABLE' 'NODES' tableName? ('FROM' databaseName)?
tableName ::=
identifier
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
| Columns | Descriptions |
|---|---|
| name | Sharding rule name |
| nodes | Sharding nodes |
Example
- Query sharding table nodes for specified table in the specified logical database
SHOW SHARDING TABLE NODES t_order_item FROM sharding_db;mysql> SHOW SHARDING TABLE NODES t_order_item FROM sharding_db;
+--------------+------------------------------------------------------------------------------------------------------------+
| name | nodes |
+--------------+------------------------------------------------------------------------------------------------------------+
| t_order_item | resource_0.t_order_item_0, resource_0.t_order_item_1, resource_1.t_order_item_0, resource_1.t_order_item_1 |
+--------------+------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)- Query sharding table nodes for specified table in the current logical database
SHOW SHARDING TABLE NODES t_order_item;mysql> SHOW SHARDING TABLE NODES t_order_item;
+--------------+------------------------------------------------------------------------------------------------------------+
| name | nodes |
+--------------+------------------------------------------------------------------------------------------------------------+
| t_order_item | resource_0.t_order_item_0, resource_0.t_order_item_1, resource_1.t_order_item_0, resource_1.t_order_item_1 |
+--------------+------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec- Query sharding table nodes for all tables in the specified logical database
SHOW SHARDING TABLE NODES FROM sharding_db;mysql> SHOW SHARDING TABLE NODES FROM sharding_db;
+--------------+------------------------------------------------------------------------------------------------------------+
| name | nodes |
+--------------+------------------------------------------------------------------------------------------------------------+
| t_order_item | resource_0.t_order_item_0, resource_0.t_order_item_1, resource_1.t_order_item_0, resource_1.t_order_item_1 |
+--------------+------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)- Query sharding table nodes for all tables in the current logical database
SHOW SHARDING TABLE NODES;mysql> SHOW SHARDING TABLE NODES;
+--------------+------------------------------------------------------------------------------------------------------------+
| name | nodes |
+--------------+------------------------------------------------------------------------------------------------------------+
| t_order_item | resource_0.t_order_item_0, resource_0.t_order_item_1, resource_1.t_order_item_0, resource_1.t_order_item_1 |
+--------------+------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 secReserved word
SHOW, SHARDING, TABLE, NODES, FROM