DROP DEFAULT SHARDING STRATEGY
语法用于删除指定逻辑库的默认分片策略。
DropDefaultShardingStrategy ::=
'DROP' 'DEFAULT' 'SHARDING' ('TABLE' | 'DATABASE') 'STRATEGY' ifExists? ('FROM' databaseName)?
ifExists ::=
'IF' 'EXISTS'
databaseName ::=
identifier
databaseName
时,默认是当前使用的 DATABASE
。 如果也未使用 DATABASE
则会提示 No database selected
;ifExists
子句用于避免 Default sharding strategy not exists
错误。DROP DEFAULT SHARDING TABLE STRATEGY FROM sharding_db;
DROP DEFAULT SHARDING DATABASE STRATEGY;
ifExists
子句删除默认表分片策略DROP DEFAULT SHARDING TABLE STRATEGY IF EXISTS;
ifExists
子句删除默认库分片策略DROP DEFAULT SHARDING DATABASE STRATEGY IF EXISTS;
DROP
、DEFAULT
、SHARDING
、TABLE
、DATABASE
、STRATEGY
、FROM