SHOW SHARDING TABLE NODES
Description
SHOW SHARDING TABLE NODES
syntax is used to query sharding table nodes in specified database.
Syntax
Grammar Railroad diagram
ShowShardingTableNode::=
'SHOW' 'SHARDING' 'TABLE' 'NODES' tableName? ('FROM' databaseName)?
tableName ::=
identifier
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
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 sec
Reserved word
SHOW
, SHARDING
, TABLE
, NODES
, FROM
Related links
当前内容版权归 ShardingSphere 或其关联方所有,如需对内容或内容相关联开源项目进行关注与资助,请访问 ShardingSphere .