You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by ji...@apache.org on 2022/11/07 07:35:25 UTC

[shardingsphere] branch master updated: Update DistSQL documents (#21987)

This is an automated email from the ASF dual-hosted git repository.

jianglongtao pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git


The following commit(s) were added to refs/heads/master by this push:
     new cb5853ddeb4 Update DistSQL documents (#21987)
cb5853ddeb4 is described below

commit cb5853ddeb472f0698650baf54dc59ecf1f996bc
Author: Zichao <57...@users.noreply.github.com>
AuthorDate: Mon Nov 7 20:35:11 2022 +1300

    Update DistSQL documents (#21987)
---
 .../db-discovery/drop-db-discovery-type.cn.md      | 49 ++++++++++++++++++++++
 .../db-discovery/drop-db-discovery-type.en.md      | 49 ++++++++++++++++++++++
 2 files changed, 98 insertions(+)

diff --git a/docs/document/content/reference/distsql/syntax/rdl/rule-definition/db-discovery/drop-db-discovery-type.cn.md b/docs/document/content/reference/distsql/syntax/rdl/rule-definition/db-discovery/drop-db-discovery-type.cn.md
new file mode 100644
index 00000000000..7f41a4795f9
--- /dev/null
+++ b/docs/document/content/reference/distsql/syntax/rdl/rule-definition/db-discovery/drop-db-discovery-type.cn.md
@@ -0,0 +1,49 @@
++++
+title = "DROP DB_DISCOVERY TYPE"
+weight = 6
++++
+
+## 描述
+
+`DROP DB_DISCOVERY TYPE` 语法用于为指定逻辑库删除数据库发现类型
+
+### 语法定义
+
+```sql
+DropDatabaseDiscoveryType ::=
+  'DROP' 'DB_DISCOVERY' 'TYPE'  dbDiscoveryTypeName (',' dbDiscoveryTypeName)*  ('FROM' databaseName)?
+
+dbDiscoveryTypeName ::=
+  identifier
+
+databaseName ::=
+  identifier
+```
+
+### 补充说明
+
+- 未指定 `databaseName` 时,默认是当前使用的 `DATABASE`。 如果也未使用 `DATABASE` 则会提示 `No database selected`
+
+- `dbDiscoveryTypeName` 需要通过 [SHOW DB_DISCOVERY TYPE](/cn/reference/distsql/syntax/rql/rule-query/db-discovery/show-db-discovery-type/) 语法查询获得
+
+### 示例
+
+- 为指定数据库删除多个数据库发现类型
+ 
+```sql
+DROP DB_DISCOVERY TYPE group_0_mysql_mgr, group_1_mysql_mgr FROM test1;
+```
+
+- 为当前数据库删除单个数据库发现类型
+
+```sql
+DROP DB_DISCOVERY TYPE group_0_mysql_mgr, group_1_mysql_mgr;
+```
+
+### 保留字
+
+`DROP`、`DB_DISCOVERY`、`TYPE`、`FROM`
+
+### 相关链接
+
+- [保留字](/cn/reference/distsql/syntax/reserved-word/)
\ No newline at end of file
diff --git a/docs/document/content/reference/distsql/syntax/rdl/rule-definition/db-discovery/drop-db-discovery-type.en.md b/docs/document/content/reference/distsql/syntax/rdl/rule-definition/db-discovery/drop-db-discovery-type.en.md
new file mode 100644
index 00000000000..3055d14cfde
--- /dev/null
+++ b/docs/document/content/reference/distsql/syntax/rdl/rule-definition/db-discovery/drop-db-discovery-type.en.md
@@ -0,0 +1,49 @@
++++
+title = "DROP DB_DISCOVERY TYPE"
+weight = 6
++++
+
+## Description
+
+The `DROP DB_DISCOVERY TYPE` syntax is used to drop database discovery type for specified database
+
+### Syntax
+
+```sql
+DropDatabaseDiscoveryType ::=
+  'DROP' 'DB_DISCOVERY' 'TYPE'  dbDiscoveryTypeName (',' dbDiscoveryTypeName)*  ('FROM' databaseName)?
+
+dbDiscoveryTypeName ::=
+  identifier
+
+databaseName ::=
+  identifier
+```
+
+### Supplement
+
+- When `databaseName` is not specified, the default is the currently used `DATABASE`. If `DATABASE` is not used, No database selected will be prompted.
+
+- `dbDiscoveryTypeName` obtain through [SHOW DB_DISCOVERY TYPE](/en/reference/distsql/syntax/rql/rule-query/db-discovery/show-db-discovery-type/) syntax query.
+
+### Example
+
+- Drop mutiple database discovery type for specified database
+
+```sql
+DROP DB_DISCOVERY TYPE group_0_mysql_mgr, group_1_mysql_mgr FROM test1;
+```
+
+- Drop single database discovery type for current database
+
+```sql
+DROP DB_DISCOVERY TYPE group_0_mysql_mgr, group_1_mysql_mgr;
+```
+
+### Reserved word
+
+`DROP`, `DB_DISCOVERY`, `TYPE`, `FROM`
+
+### Related links
+
+- [Reserved word](/en/reference/distsql/syntax/reserved-word/)