Skip to content

Latest commit

 

History

History
43 lines (31 loc) · 868 Bytes

sql-statement-show-placement-labels.md

File metadata and controls

43 lines (31 loc) · 868 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.

Synopsis

ShowStmt ::=
    "PLACEMENT" "LABELS"

Examples

{{< copyable "sql" >}}

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