Skip to content

Latest commit

 

History

History
49 lines (36 loc) · 1.11 KB

sql-statement-show-placement-labels.md

File metadata and controls

49 lines (36 loc) · 1.11 KB
title summary
SHOW PLACEMENT LABELS
The usage of SHOW PLACEMENT LABELS in TiDB.

SHOW PLACEMENT LABELS

Warning:

Placement Rules in SQL is an experimental feature. The syntax might change before its GA, and there might also be bugs.

If you understand the risks, you can enable this experiment feature by executing SET GLOBAL tidb_enable_alter_placement = 1;.

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