SHOW SHARDING TABLE NODES

Syntax

• 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

• 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

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;

• Query sharding table nodes for all tables in the current logical database

SHOW SHARDING TABLE NODES;

mysql> SHOW SHARDING TABLE 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 |
+--------------+------------------------------------------------------------------------------------------------------------+

Reserved word