SHOW BROADCAST TABLE RULES
Description
The SHOW BROADCAST TABLE RULES syntax is used to query broadcast table rules for specified database.
Syntax
ShowBroadcastTableRule ::=
'SHOW' 'BROADCAST' 'TABLE' 'RULES' ('FROM' databaseName)?
databaseName ::=
identifierSupplement
- When
databaseNameis not specified, the default is the currently usedDATABASE. IfDATABASEis not used,No database selectedwill be prompted.
Return value description
| Column | Description |
|---|---|
| broadcast_table | Broadcast table name |
Example
- Query broadcast tables for specified database.
SHOW BROADCAST TABLE RULES FROM sharding_db;mysql> SHOW BROADCAST TABLE RULES FROM sharding_db;
+-----------------+
| broadcast_table |
+-----------------+
| t_a |
| t_b |
| t_c |
+-----------------+
3 rows in set (0.00 sec)- Query broadcast table for current database.
SHOW BROADCAST TABLE RULES;mysql> SHOW BROADCAST TABLE RULES;
+-----------------+
| broadcast_table |
+-----------------+
| t_a |
| t_b |
| t_c |
+-----------------+
3 rows in set (0.00 sec)Reserved word
SHOW, BROADCAST, TABLE, RULES