Skip to content

Latest commit

 

History

History
45 lines (33 loc) · 1018 Bytes

sql-statement-show-placement-labels.md

File metadata and controls

45 lines (33 loc) · 1018 Bytes
Raw
title summary
SHOW PLACEMENT LABELS
The usage of SHOW PLACEMENT LABELS in TiDB.

SHOW PLACEMENT LABELS

SHOW PLACEMENT LABELS is used to summarize the labels and values that are available for Placement Rules.

Note:

This feature is not available on TiDB Serverless clusters.

Synopsis

ShowStmt ::=
    "SHOW" "PLACEMENT" "LABELS" ShowLikeOrWhere?

Examples

SHOW PLACEMENT LABELS;
+--------+----------------+
| Key    | Values         |
+--------+----------------+
| region | ["us-east-1"]  |
| zone   | ["us-east-1a"] |
+--------+----------------+
2 rows in set (0.00 sec)

MySQL compatibility

This statement is a TiDB extension to MySQL syntax.

See also