The SHOW BROADCAST TABLE RULE syntax is used to broadcast tables for specified database.
ShowBroadcastTableRule ::=
'SHOW' 'BROADCAST' 'TABLE' 'RULES' ('FROM' databaseName)?
databaseName ::=
identifier
databaseName is not specified, the default is the currently used DATABASE. If DATABASE is not used, No database selected will be prompted.| Column | Description |
|---|---|
| broadcast_table | Broadcast table name |
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)
SHOW BROADCAST TABLE RULES;
mysql> SHOW BROADCAST TABLE RULES;
+-----------------+
| broadcast_table |
+-----------------+
| t_a |
| t_b |
| t_c |
+-----------------+
3 rows in set (0.00 sec)
SHOW, BROADCAST, TABLE, RULES