DROP READWRITE_SPLITTING RULE
描述
DROP READWRITE_SPLITTING RULE 语法用于从当前逻辑库中删除读写分离规则。
语法定义
DropReadwriteSplittingRule ::=
'DROP' 'READWRITE_SPLITTING' 'RULE' ifExists? ruleName (',' ruleName)*
ifExists ::=
'IF' 'EXISTS'
ruleName ::=
identifier补充说明
ifExists子句用于避免Readwrite-splitting rule not exists错误。
示例
- 删除读写分离规则
DROP READWRITE_SPLITTING RULE ms_group_1;- 删除多个读写分离规则
DROP READWRITE_SPLITTING RULE ms_group_1, ms_group_2;- 使用
ifExists子句删除读写分离规则
DROP READWRITE_SPLITTING RULE IF EXISTS ms_group_1;保留字
DROP、READWRITE_SPLITTING、RULE、IF、EXISTS