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