SHOW BROADCAST TABLE RULE

Description

The SHOW BROADCAST TABLE RULE syntax is used to broadcast tables for specified database.

Syntax

Grammar Railroad diagram

  1. ShowBroadcastTableRule ::=
  2.   'SHOW' 'BROADCAST' 'TABLE' 'RULES' ('FROM' databaseName)? 
  4. databaseName ::=
  5.   identifier

Supplement

  • When databaseName is not specified, the default is the currently used DATABASE. If DATABASE is not used, No database selected will be prompted.

Return value description

ColumnDescription
broadcast_tableBroadcast table name

Example

  • Query broadcast tables for specified database.
  1. SHOW BROADCAST TABLE RULES FROM sharding_db;
  1. mysql> SHOW BROADCAST TABLE RULES FROM sharding_db;
  2. +-----------------+
  3. | broadcast_table |
  4. +-----------------+
  5. | t_a             |
  6. | t_b             |
  7. | t_c             |
  8. +-----------------+
  9. 3 rows in set (0.00 sec)
  • Query broadcast table for current database.
  1. SHOW BROADCAST TABLE RULES;
  1. mysql> SHOW BROADCAST TABLE RULES;
  2. +-----------------+
  3. | broadcast_table |
  4. +-----------------+
  5. | t_a             |
  6. | t_b             |
  7. | t_c             |
  8. +-----------------+
  9. 3 rows in set (0.00 sec)

Reserved word

SHOW, BROADCAST, TABLE, RULES