morrySnow commented on code in PR #1898:
URL: https://github.com/apache/doris-website/pull/1898#discussion_r1925157731


##########
docs/sql-manual/sql-statements/table-and-view/table/SHOW-CONVERT-LIGHT-SCHEMA-CHANGE-PROCESS.md:
##########
@@ -24,34 +24,43 @@ specific language governing permissions and limitations
 under the License.
 -->
 
-
 ## Description
 
-This statement is used to show the process of converting light schema change 
process. should enable config `enable_convert_light_weight_schema_change`.
+Used to view the conversion of non-light schema change olpa tables to light 
schema change tables.

Review Comment:
   ```suggestion
   Used to view the conversion process of non-light schema change OLAP tables 
to light schema change tables.
   ```



##########
docs/sql-manual/sql-statements/table-and-view/table/SHOW-TABLE-ID.md:
##########
@@ -24,28 +24,49 @@ specific language governing permissions and limitations
 under the License.
 -->
 
-
 ### Description
 
-This statement is used to find the corresponding database name, table name 
according to the table id (only for administrators)
+This statement is used to find the corresponding database name, table name 
according to table id (only for administrators).

Review Comment:
   ```suggestion
   This statement is used to find the corresponding database name, table name 
according to table id.
   ```



##########
docs/sql-manual/sql-statements/table-and-view/table/SHOW-CONVERT-LIGHT-SCHEMA-CHANGE-PROCESS.md:
##########
@@ -24,34 +24,43 @@ specific language governing permissions and limitations
 under the License.
 -->
 
-
 ## Description
 
-This statement is used to show the process of converting light schema change 
process. should enable config `enable_convert_light_weight_schema_change`.
+Used to view the conversion of non-light schema change olpa tables to light 
schema change tables.
 
-grammar:
+## Syntax
 
 ```sql
-SHOW CONVERT_LIGHT_SCHEMA_CHANGE_PROCESS [FROM db]
+SHOW CONVERT_LIGHT_SCHEMA_CHANGE_PROCESS [ FROM <db_name> ]
 ```
 
-## Example
+## Optional parameters
+
+**1. `FROM clause`**

Review Comment:
   ```suggestion
   **1. `<db_name>`**
   ```



##########
docs/sql-manual/sql-statements/table-and-view/table/SHOW-TABLE-STATUS.md:
##########
@@ -24,39 +24,87 @@ specific language governing permissions and limitations
 under the License.
 -->
 
-
 ## Description
 
-This statement is used to view some information about the Table.
+This statement is used to display some information about a table or view.

Review Comment:
   information 太笼统了



##########
docs/sql-manual/sql-statements/table-and-view/table/SHOW-TABLE-STATUS.md:
##########
@@ -24,39 +24,87 @@ specific language governing permissions and limitations
 under the License.
 -->
 
-
 ## Description
 
-This statement is used to view some information about the Table.
+This statement is used to display some information about a table or view.
 
-grammar:
+## Syntax
 
 ```sql
-SHOW TABLE STATUS
-[FROM db] [LIKE "pattern"]
+SHOW TABLE STATUS [ FROM [ <catalog_name>.]<db_name> ] [ LIKE <like_condition> 
]
 ```
-
-illustrate:
-
-1. This statement is mainly used to be compatible with MySQL syntax, currently 
only a small amount of information such as Comment is displayed
-
-## Example
-
-  1. View the information of all tables under the current database
-
-     ```sql
-     SHOW TABLE STATUS;
-     ```
-
-  2. View the information of the table whose name contains example under the 
specified database
-
-     ```sql
-     SHOW TABLE STATUS FROM db LIKE "%example%";
-     ```
-
-## Keywords
-
-    SHOW, TABLE, STATUS
-
-## Best Practice
+## Optional parameters
+
+**1. `FROM clause`**
+> The catalog name and database name to be queried can be specified in the 
FROM clause.
+
+**2. `LIKE clause`**
+> The LIKE clause can perform fuzzy queries based on the table name.
+
+## Return value
+
+| Column name (Column) | Type (DataType) | Notes (Notes) |
+|:--------------------|:-------------|:----------------|
+| Name | String | Table name |
+| Engine | String | Table engine |
+| Version | String | |
+| Row_format | String | |
+| Rows | String | Number of rows in the table |
+| Avg_row_length | Integer | Average length of each row of data |
+| Data_length | Integer | Data size of the table |
+| Max_data_length | Integer | Maximum length of the data row |
+| Index_length | Integer | Length of the index |
+| Data_free | | |
+| Auto_increment | | |
+| Create_time | Datetime | Creation time |
+| Update_time | Datetime | Update time |
+| Check_time | Datetime | |
+| Collation | Character set | Character set, currently only supports utf-8 |

Review Comment:
   ```suggestion
   | Collation | string | Character set, currently only supports utf-8 |
   ```



##########
docs/sql-manual/sql-statements/table-and-view/table/SHOW-TABLE-STATUS.md:
##########
@@ -24,39 +24,87 @@ specific language governing permissions and limitations
 under the License.
 -->
 
-
 ## Description
 
-This statement is used to view some information about the Table.
+This statement is used to display some information about a table or view.
 
-grammar:
+## Syntax
 
 ```sql
-SHOW TABLE STATUS
-[FROM db] [LIKE "pattern"]
+SHOW TABLE STATUS [ FROM [ <catalog_name>.]<db_name> ] [ LIKE <like_condition> 
]
 ```
-
-illustrate:
-
-1. This statement is mainly used to be compatible with MySQL syntax, currently 
only a small amount of information such as Comment is displayed
-
-## Example
-
-  1. View the information of all tables under the current database
-
-     ```sql
-     SHOW TABLE STATUS;
-     ```
-
-  2. View the information of the table whose name contains example under the 
specified database
-
-     ```sql
-     SHOW TABLE STATUS FROM db LIKE "%example%";
-     ```
-
-## Keywords
-
-    SHOW, TABLE, STATUS
-
-## Best Practice
+## Optional parameters
+
+**1. `FROM clause`**
+> The catalog name and database name to be queried can be specified in the 
FROM clause.
+
+**2. `LIKE clause`**
+> The LIKE clause can perform fuzzy queries based on the table name.
+
+## Return value
+
+| Column name (Column) | Type (DataType) | Notes (Notes) |
+|:--------------------|:-------------|:----------------|
+| Name | String | Table name |
+| Engine | String | Table engine |
+| Version | String | |
+| Row_format | String | |
+| Rows | String | Number of rows in the table |
+| Avg_row_length | Integer | Average length of each row of data |
+| Data_length | Integer | Data size of the table |
+| Max_data_length | Integer | Maximum length of the data row |
+| Index_length | Integer | Length of the index |
+| Data_free | | |
+| Auto_increment | | |
+| Create_time | Datetime | Creation time |
+| Update_time | Datetime | Update time |
+| Check_time | Datetime | |
+| Collation | Character set | Character set, currently only supports utf-8 |
+| Checksum | String | |
+| Create_options | string | |

Review Comment:
   缺少说明



##########
docs/sql-manual/sql-statements/table-and-view/table/SHOW-TABLE-STATUS.md:
##########
@@ -24,39 +24,87 @@ specific language governing permissions and limitations
 under the License.
 -->
 
-
 ## Description
 
-This statement is used to view some information about the Table.
+This statement is used to display some information about a table or view.
 
-grammar:
+## Syntax
 
 ```sql
-SHOW TABLE STATUS
-[FROM db] [LIKE "pattern"]
+SHOW TABLE STATUS [ FROM [ <catalog_name>.]<db_name> ] [ LIKE <like_condition> 
]
 ```
-
-illustrate:
-
-1. This statement is mainly used to be compatible with MySQL syntax, currently 
only a small amount of information such as Comment is displayed
-
-## Example
-
-  1. View the information of all tables under the current database
-
-     ```sql
-     SHOW TABLE STATUS;
-     ```
-
-  2. View the information of the table whose name contains example under the 
specified database
-
-     ```sql
-     SHOW TABLE STATUS FROM db LIKE "%example%";
-     ```
-
-## Keywords
-
-    SHOW, TABLE, STATUS
-
-## Best Practice
+## Optional parameters
+
+**1. `FROM clause`**
+> The catalog name and database name to be queried can be specified in the 
FROM clause.
+
+**2. `LIKE clause`**
+> The LIKE clause can perform fuzzy queries based on the table name.
+
+## Return value
+
+| Column name (Column) | Type (DataType) | Notes (Notes) |
+|:--------------------|:-------------|:----------------|
+| Name | String | Table name |
+| Engine | String | Table engine |
+| Version | String | |
+| Row_format | String | |
+| Rows | String | Number of rows in the table |
+| Avg_row_length | Integer | Average length of each row of data |
+| Data_length | Integer | Data size of the table |
+| Max_data_length | Integer | Maximum length of the data row |
+| Index_length | Integer | Length of the index |
+| Data_free | | |
+| Auto_increment | | |

Review Comment:
   这俩忘记写数据类型了?



##########
docs/sql-manual/sql-statements/table-and-view/table/SHOW-TABLE-STATUS.md:
##########
@@ -24,39 +24,87 @@ specific language governing permissions and limitations
 under the License.
 -->
 
-
 ## Description
 
-This statement is used to view some information about the Table.
+This statement is used to display some information about a table or view.
 
-grammar:
+## Syntax
 
 ```sql
-SHOW TABLE STATUS
-[FROM db] [LIKE "pattern"]
+SHOW TABLE STATUS [ FROM [ <catalog_name>.]<db_name> ] [ LIKE <like_condition> 
]
 ```
-
-illustrate:
-
-1. This statement is mainly used to be compatible with MySQL syntax, currently 
only a small amount of information such as Comment is displayed
-
-## Example
-
-  1. View the information of all tables under the current database
-
-     ```sql
-     SHOW TABLE STATUS;
-     ```
-
-  2. View the information of the table whose name contains example under the 
specified database
-
-     ```sql
-     SHOW TABLE STATUS FROM db LIKE "%example%";
-     ```
-
-## Keywords
-
-    SHOW, TABLE, STATUS
-
-## Best Practice
+## Optional parameters
+
+**1. `FROM clause`**

Review Comment:
   ```suggestion
   **1. `FROM [ <catalog_name>.]<db_name>`**
   ```



##########
docs/sql-manual/sql-statements/table-and-view/table/SHOW-TABLE-STATUS.md:
##########
@@ -24,39 +24,87 @@ specific language governing permissions and limitations
 under the License.
 -->
 
-
 ## Description
 
-This statement is used to view some information about the Table.
+This statement is used to display some information about a table or view.
 
-grammar:
+## Syntax
 
 ```sql
-SHOW TABLE STATUS
-[FROM db] [LIKE "pattern"]
+SHOW TABLE STATUS [ FROM [ <catalog_name>.]<db_name> ] [ LIKE <like_condition> 
]
 ```
-
-illustrate:
-
-1. This statement is mainly used to be compatible with MySQL syntax, currently 
only a small amount of information such as Comment is displayed
-
-## Example
-
-  1. View the information of all tables under the current database
-
-     ```sql
-     SHOW TABLE STATUS;
-     ```
-
-  2. View the information of the table whose name contains example under the 
specified database
-
-     ```sql
-     SHOW TABLE STATUS FROM db LIKE "%example%";
-     ```
-
-## Keywords
-
-    SHOW, TABLE, STATUS
-
-## Best Practice
+## Optional parameters
+
+**1. `FROM clause`**
+> The catalog name and database name to be queried can be specified in the 
FROM clause.
+
+**2. `LIKE clause`**
+> The LIKE clause can perform fuzzy queries based on the table name.
+
+## Return value
+
+| Column name (Column) | Type (DataType) | Notes (Notes) |

Review Comment:
   ```suggestion
   | Column | Data Type | Notes |
   ```



##########
docs/sql-manual/sql-statements/table-and-view/table/SHOW-TABLE-STATUS.md:
##########
@@ -24,39 +24,87 @@ specific language governing permissions and limitations
 under the License.
 -->
 
-
 ## Description
 
-This statement is used to view some information about the Table.
+This statement is used to display some information about a table or view.
 
-grammar:
+## Syntax
 
 ```sql
-SHOW TABLE STATUS
-[FROM db] [LIKE "pattern"]
+SHOW TABLE STATUS [ FROM [ <catalog_name>.]<db_name> ] [ LIKE <like_condition> 
]
 ```
-
-illustrate:
-
-1. This statement is mainly used to be compatible with MySQL syntax, currently 
only a small amount of information such as Comment is displayed
-
-## Example
-
-  1. View the information of all tables under the current database
-
-     ```sql
-     SHOW TABLE STATUS;
-     ```
-
-  2. View the information of the table whose name contains example under the 
specified database
-
-     ```sql
-     SHOW TABLE STATUS FROM db LIKE "%example%";
-     ```
-
-## Keywords
-
-    SHOW, TABLE, STATUS
-
-## Best Practice
+## Optional parameters
+
+**1. `FROM clause`**
+> The catalog name and database name to be queried can be specified in the 
FROM clause.
+
+**2. `LIKE clause`**

Review Comment:
   ```suggestion
   **2. `<like_condition>`**
   ```



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to