Broadcast Table

Broadcast Table #

Syntax	Description	Type
CREATE BROADCAST TABLE RULE tableName [, tableName] …	Create broadcast table	RDL
DROP BROADCAST TABLE RULES tableName [, tableName] …	Delete broadcast table	RDL
SHOW BROADCAST TABLE RULES [FROM databaseName]	View broadcast table	RQL

1. Create Broadcast Table #

CREATE BROADCAST TABLE RULE tableName [, tableName] ...

Parameter Description

Name	Data type	Description
tableName	IDENTIFIER	Table name

Example

CREATE BROADCAST TABLE RULE t_a,t_b;

2. Delete Broadcast Table #

DROP BROADCAST TABLE RULES tableName [, tableName] ...

Parameter Description

Name	Data type	Description
tableName	IDENTIFIER	Table name

Example

DROP BROADCAST TABLE RULE t_a;

3. View Broadcast Table #

SHOW BROADCAST TABLE RULES [FROM databaseName]

Parameter Description

Name	Data type	Description
databaseName	IDENTIFIER	Logical database name

Example

mysql> SHOW BROADCAST TABLE RULES;
+------------------------+
| broadcast_table        |
+------------------------+
| t_1                    |
| t_2                    |
+------------------------+
2 rows in set (0.00 sec)

Output Description

Name	Description
broadcast_table	Broadcast table name