This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/incubator-doris.git
The following commit(s) were added to refs/heads/master by this push:
new cfe22f8691 [Doc]Add show tables help documentation (#9568)
cfe22f8691 is described below
commit cfe22f86919e995ec551dc40170e3038d418ffee
Author: jiafeng.zhang <[email protected]>
AuthorDate: Sun May 15 10:18:33 2022 +0800
[Doc]Add show tables help documentation (#9568)
---
docs/.vuepress/sidebar/en.js | 1 +
docs/.vuepress/sidebar/zh-CN.js | 1 +
.../sql-reference/Show-Statements/SHOW-TABLES.md | 83 ++++++++++++++++++++++
.../sql-reference/Show-Statements/SHOW-TABLES.md | 83 ++++++++++++++++++++++
4 files changed, 168 insertions(+)
diff --git a/docs/.vuepress/sidebar/en.js b/docs/.vuepress/sidebar/en.js
index ee1c9f532c..5ccf75082a 100644
--- a/docs/.vuepress/sidebar/en.js
+++ b/docs/.vuepress/sidebar/en.js
@@ -777,6 +777,7 @@ module.exports = [
"SHOW-STREAM-LOAD",
"SHOW-SYNC-JOB",
"SHOW-TABLE-ID",
+ "SHOW-TABLES",
"SHOW-TABLE-STATUS",
"SHOW-TABLET",
"SHOW-TRANSACTION",
diff --git a/docs/.vuepress/sidebar/zh-CN.js b/docs/.vuepress/sidebar/zh-CN.js
index 899b5d94f8..330c25db57 100644
--- a/docs/.vuepress/sidebar/zh-CN.js
+++ b/docs/.vuepress/sidebar/zh-CN.js
@@ -777,6 +777,7 @@ module.exports = [
"SHOW-STREAM-LOAD",
"SHOW-SYNC-JOB",
"SHOW-TABLE-ID",
+ "SHOW-TABLES",
"SHOW-TABLE-STATUS",
"SHOW-TABLET",
"SHOW-TRANSACTION",
diff --git a/docs/en/sql-manual/sql-reference/Show-Statements/SHOW-TABLES.md
b/docs/en/sql-manual/sql-reference/Show-Statements/SHOW-TABLES.md
new file mode 100644
index 0000000000..96cb124cd5
--- /dev/null
+++ b/docs/en/sql-manual/sql-reference/Show-Statements/SHOW-TABLES.md
@@ -0,0 +1,83 @@
+---
+{
+ "title": "SHOW-TABLES",
+ "language": "en"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## SHOW-TABLES
+
+### Name
+
+SHOW TABLES
+
+### Description
+
+This statement is used to display all tables under the current db
+
+grammar:
+
+```sql
+SHOW TABLES [LIKE]
+````
+
+illustrate:
+
+1. LIKE: Fuzzy query can be performed according to the table name
+
+### Example
+
+ 1. View all tables under DB
+
+ ```sql
+ mysql> show tables;
+ +---------------------------------+
+ | Tables_in_demo |
+ +---------------------------------+
+ | ads_client_biz_aggr_di_20220419 |
+ | cmy1 |
+ | cmy2 |
+ | intern_theme |
+ | left_table |
+ +---------------------------------+
+ 5 rows in set (0.00 sec)
+ ````
+
+2. Fuzzy query by table name
+
+ ```sql
+ mysql> show tables like '%cm%';
+ +----------------+
+ | Tables_in_demo |
+ +----------------+
+ | cmy1 |
+ | cmy2 |
+ +----------------+
+ 2 rows in set (0.00 sec)
+ ````
+
+### Keywords
+
+ SHOW, TABLES
+
+### Best Practice
+
diff --git a/docs/zh-CN/sql-manual/sql-reference/Show-Statements/SHOW-TABLES.md
b/docs/zh-CN/sql-manual/sql-reference/Show-Statements/SHOW-TABLES.md
new file mode 100644
index 0000000000..59a98c855b
--- /dev/null
+++ b/docs/zh-CN/sql-manual/sql-reference/Show-Statements/SHOW-TABLES.md
@@ -0,0 +1,83 @@
+---
+{
+ "title": "SHOW-TABLES",
+ "language": "zh-CN"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## SHOW-TABLES
+
+### Name
+
+SHOW TABLES
+
+### Description
+
+该语句用于展示当前 db 下所有的 table
+
+语法：
+
+```sql
+SHOW TABLES [LIKE]
+```
+
+说明:
+
+1. LIKE：可按照表名进行模糊查询
+
+### Example
+
+ 1. 查看DB下所有表
+
+ ```sql
+ mysql> show tables;
+ +---------------------------------+
+ | Tables_in_demo |
+ +---------------------------------+
+ | ads_client_biz_aggr_di_20220419 |
+ | cmy1 |
+ | cmy2 |
+ | intern_theme |
+ | left_table |
+ +---------------------------------+
+ 5 rows in set (0.00 sec)
+ ```
+
+2. 按照表名进行模糊查询
+
+ ```sql
+ mysql> show tables like '%cm%';
+ +----------------+
+ | Tables_in_demo |
+ +----------------+
+ | cmy1 |
+ | cmy2 |
+ +----------------+
+ 2 rows in set (0.00 sec)
+ ```
+
+### Keywords
+
+ SHOW, TABLES
+
+### Best Practice
+
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
