SHOW UNUSED SHARDING ALGORITHMS

Description

The SHOW UNUSED SHARDING ALGORITHMS syntax is used to query the unused sharding algorithms in the specified database.

Syntax

  1. ShowShardingAlgorithms::=
  2.   'SHOW' 'UNUSED' 'SHARDING' 'ALGORITHMS' ('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

ColumnDescription
nameSharding algorithm name
typeSharding algorithm type
propsSharding algorithm properties

Example

  • Query the unused sharding table algorithms of the specified logical database
  1. SHOW UNUSED SHARDING ALGORITHMS;
  1. mysql> SHOW UNUSED SHARDING ALGORITHMS;
  2. +---------------+--------+-----------------------------------------------------+
  3. | name          | type   | props                                               |
  4. +---------------+--------+-----------------------------------------------------+
  5. | t1_inline     | INLINE | algorithm-expression=t_order_${order_id % 2}        |
  6. +---------------+--------+-----------------------------------------------------+
  7. 1 row in set (0.01 sec)

Reserved word

SHOW, UNUSED, SHARDING, ALGORITHMS, FROM