Retro Eye care Haitian Deep Dark Default

SHOW SHARDING KEY GENERATOR

Description

SHOW SHARDING KEY GENERATOR syntax is used to query sharding key generators in specified database.

Syntax

ShowShardingKeyGenerators::=
  'SHOW' 'SHARDING' 'KEY' ('GENERATOR' keyGeneratorName | 'GENERATORS') ('FROM' databaseName)?

keyGeneratorName ::=
  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.
  • Use SHOW SHARDING KEY GENERATORS to query all sharding key generators.
  • Use SHOW SHARDING KEY GENERATOR keyGeneratorName to query the specified sharding key generator.

Return value description

column Description
name Sharding key generator name
type Sharding key generator type
props Sharding key generator properties

Example

  • Query the sharding key generators of the specified logical database
SHOW SHARDING KEY GENERATORS FROM sharding_db;

mysql> SHOW SHARDING KEY GENERATORS FROM sharding_db;
+-------------------------+-----------+-------+
| name                    | type      | props |
+-------------------------+-----------+-------+
| snowflake_key_generator | snowflake |       |
+-------------------------+-----------+-------+
1 row in set (0.00 sec)
  • Query the sharding key generators of the current logical database
SHOW SHARDING KEY GENERATORS;

mysql> SHOW SHARDING KEY GENERATORS;
+-------------------------+-----------+-------+
| name                    | type      | props |
+-------------------------+-----------+-------+
| snowflake_key_generator | snowflake |       |
+-------------------------+-----------+-------+
1 row in set (0.00 sec)
  • Query the specified sharding key generator
SHOW SHARDING KEY GENERATOR snowflake_key_generator;

mysql> SHOW SHARDING KEY GENERATOR snowflake_key_generator;
+-------------------------+-----------+-------+
| name                    | type      | props |
+-------------------------+-----------+-------+
| snowflake_key_generator | snowflake |       |
+-------------------------+-----------+-------+
1 row in set (0.00 sec)

Reserved word

SHOW, SHARDING, KEY, GENERATOR, GENERATORS, FROM