DROP READWRITE_SPLITTING RULE
描述
DROP READWRITE_SPLITTING RULE
语法用于为指定逻辑库删除读写分离
语法定义
语法 铁路图
DropReadwriteSplittingRule ::=
'DROP' 'READWRITE_SPLITTING' 'RULE' ifExists? readwriteSplittingRuleName (',' readwriteSplittingRuleName)* ('FROM' databaseName)?
ifExists ::=
'IF' 'EXISTS'
readwriteSplittingRuleName ::=
identifier
databaseName ::=
identifier
补充说明
- 未指定
databaseName
时,默认是当前使用的DATABASE
。 如果也未使用DATABASE
则会提示No database selected
; ifExists
子句用于避免Readwrite splitting rule not exists
错误。
示例
- 为指定逻辑库删除读写分离规则
DROP READWRITE_SPLITTING RULE ms_group_1 FROM readwrite_splitting_db;
- 为当前逻辑库删除读写分离规则
DROP READWRITE_SPLITTING RULE ms_group_1;
- 使用
ifExists
子句删除读写分离规则
DROP READWRITE_SPLITTING RULE IF EXISTS ms_group_1;
保留字
DROP
、READWRITE_SPLITTING
、RULE
相关链接
当前内容版权归 ShardingSphere 或其关联方所有,如需对内容或内容相关联开源项目进行关注与资助,请访问 ShardingSphere .