SHOW SHARDING TABLE NODES

Description

SHOW SHARDING TABLE NODES syntax is used to query sharding table nodes in specified database.

Syntax

  1. ShowShardingTableNode::=
  2.   'SHOW' 'SHARDING' 'TABLE' 'NODE'('FROM' databaseName)?
  4. databaseName ::=
  5.   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

ColumnsDescriptions
nameSharding rule name
nodesSharding nodes

Example

  • Query sharding table nodes for the specified logical database
  1. SHOW SHARDING TABLE NODES FROM test1;
  1. mysql> SHOW SHARDING TABLE NODES FROM test1;
  2. +--------------+------------------------------------------------------------------------------------------------------------+
  3. | name         | nodes                                                                                                      |
  4. +--------------+------------------------------------------------------------------------------------------------------------+
  5. | 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 |
  6. +--------------+------------------------------------------------------------------------------------------------------------+
  7. 1 row in set (0.00 sec)
  • Query sharding table nodes for the current logical database
  1. SHOW SHARDING TABLE NODES;
  1. mysql> SHOW SHARDING TABLE NODES;
  2. +--------------+------------------------------------------------------------------------------------------------------------+
  3. | name         | nodes                                                                                                      |
  4. +--------------+------------------------------------------------------------------------------------------------------------+
  5. | 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 |
  6. +--------------+------------------------------------------------------------------------------------------------------------+
  7. 1 row in set (0.00 sec

Reserved word

SHOW, SHARDING, TABLE, NODE, FROM