Logo
表关联

表关联 #

语法描述类型
CREATE SHARDING TABLE REFERENCE RULE tableReferenceRuleDefinition [, tableReferenceRuleDefinition] …创建分片表关联RDL
ALTER SHARDING TABLE REFERENCE RULE tableReferenceRuleDefinition [, tableReferenceRuleDefinition] …修改分片表关联RDL
ALTER SHARDING BINDING TABLE RULE TO仅SphereEx-Console 使用，文档中未做说明RDL
DROP SHARDING TABLE REFERENCE RULE tableReferenceRuleDefinition [, tableReferenceRuleDefinition] …删除表关联RDL
SHOW SHARDING TABLE REFERENCE RULES [FROM databaseName]查看表关联RQL
SHOW SHARDING TABLE REFERENCE RULE ruleName1.3.0 版本中实现RQL

1. 创建分片表关联 #

CREATE SHARDING TABLE REFERENCE RULE tableReferenceRuleDefinition [, tableReferenceRuleDefinition] ...
tableReferenceRuleDefinition:
    (tableName [, tableName] ... )

示例

CREATE SHARDING TABLE REFERENCE RULE (t_order,t_order_item),(t_1,t_2);

2. 修改分片表关联 #

ALTER SHARDING TABLE REFERENCE RULE tableReferenceRuleDefinition [, tableReferenceRuleDefinition] ...

tableReferenceRuleDefinition:
    (tableName [, tableName] ... )

示例

ALTER SHARDING TABLE REFERENCE RULE (t_order,t_order_item);

3. 删除分片表关联 #

DROP SHARDING TABLE REFERENCE RULE tableReferenceRuleDefinition [, tableReferenceRuleDefinition] ...

tableReferenceRuleDefinition:
    (tableName [, tableName] ... )

示例

删除所有表关联

DROP SHARDING TABLE REFERENCE RULE;

删除指定表关联

DROP SHARDING TABLE REFERENCE RULE (t_order,t_order_item);

4. 查看表关联 #

SHOW SHARDING TABLE REFERENCE RULES;

参数说明

无

示例

mysql> SHOW SHARDING TABLE REFERENCE RULES;
+--------------------------+
| sharding_table_reference |
+--------------------------+
| t_order,t_order_item     |
| t1,t2                    |
+--------------------------+
2 rows in set (0.00 sec)

输出说明

列说明
sharding_table_reference表关联关系