CREATE SHARDING BROADCAST TABLE RULE

    • 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 use to modify the broadcast table rule.

    Create sharding broadcast table rule

    1. -- Add t_province, t_city to broadcast table rules
    2. CREATE SHARDING BROADCAST TABLE RULES (t_province, t_city);

    , SHARDING, BROADCAST, , RULES