sql-statement-show-placement-labels.md

title	summary
SHOW PLACEMENT LABELS	TiDB 数据库中 SHOW PLACEMENT LABELS 的使用概况。

SHOW PLACEMENT LABELS

SHOW PLACEMENT LABELS 汇总可用于放置规则 (Placement Rules) 的标签 (label) 和值。

语法图

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

示例

SHOW PLACEMENT LABELS;

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

MySQL 兼容性

该语句是 TiDB 对 MySQL 语法的扩展。

另请参阅

• Placement Rules in SQL
• SHOW PLACEMENT
• CREATE PLACEMENT POLICY