CREATE SHARDING BROADCAST TABLE RULE
Description
The CREATE SHARDING BROADCAST TABLE RULE
syntax is used to create broadcast table rules for tables that need to be broadcast (broadcast tables)
Syntax
CreateBroadcastTableRule ::=
'CREATE' 'SHARDING' 'BROADCAST' 'TABLE' 'RULES' '(' tableName (',' tableName)* ')'
tableName ::=
identifier
Supplement
tableName
can use an existing table or a table that will be created;- Only one broadcast rule can exist, but can contain multiple broadcast tables, so can not execute
CREATE SHARDING BROADCAST TABLE RULE
more than one time. When the broadcast table rule already exists but the broadcast table needs to be added, you need to useALTER BROADCAST TABLE RULE
to modify the broadcast table rule.
Example
Create sharding broadcast table rule
-- Add t_province, t_city to broadcast table rules
CREATE SHARDING BROADCAST TABLE RULES (t_province, t_city);
Reserved word
CREATE
, SHARDING
, BROADCAST
, TABLE
, RULES
Related links
当前内容版权归 ShardingSphere 或其关联方所有,如需对内容或内容相关联开源项目进行关注与资助,请访问 ShardingSphere .