constant
INT_VALUE Matching type integer constants, such as: One hundred and twenty-three . DECIMAL_VALUE Matching: fixed type constant, such as One hundred and twenty-three point four five six . STR_VALUE Matching string constants, such as: ABC . NULL Matching: NULL constant. STORAGE_SIZE Storage: matching length integer constants, the default unit for byte string can be specified in M or G, such as One thousand and twenty-four or '500M' .
One Two Three Four Five Six Seven Eight Nine Ten Eleven | Const_value : INT_VALUE | DECIMAL_VALUE | STR_VALUE | NULL | STORAGE_SIZE STORAGE_SIZE : INT_VALUE | 'INT_VALUE[M|G]' |
character set
One Two Three Four Five Six Seven Eight Nine Ten | Charset : Default_charset | Column_charset Default_charset : [ DEFAULT ] { CHARSET | CHARACTER SET } [ = ] { UTF8 | UTF8MB4 | BINARY } Column_charset : { CHARSET | CHARACTER SET } { UTF8 | UTF8MB4 | BINARY } |
Sort rules
One Two Three Four Five Six Seven Eight Nine Ten | Collate : Default_collate | Column_collate Default_collate : [ DEFAULT ] COLLATE [ = ] { UTF8MB4_GENERAL_CI | UTF8MB4_BIN | BINARY } Column_collate : COLLATE { UTF8MB4_GENERAL_CI | UTF8MB4_BIN | BINARY } |
data type
One Two Three Four Five Six Seven Eight Nine Ten Eleven Twelve Thirteen Fourteen Fifteen Sixteen Seventeen Eighteen Nineteen Twenty Twenty-one Twenty-two Twenty-three Twenty-four Twenty-five Twenty-six Twenty-seven Twenty-eight Twenty-nine Thirty Thirty-one Thirty-two | Data_type : TINYINT [ ( Precision ) ] [ UNSIGNED ] [ ZEROFILL ] | SMALLINT [ ( Precision ) ] [ UNSIGNED ] [ ZEROFILL ] | MEDIUMINT [ ( Precision ) ] [ UNSIGNED ] [ ZEROFILL ] | INT [ ( Precision ) ] [ UNSIGNED ] [ ZEROFILL ] | INTEGER [ ( Precision ) ] [ UNSIGNED ] [ ZEROFILL ] | BIGINT [ ( Precision ) ] [ UNSIGNED ] [ ZEROFILL ] | FLOAT [ ( Precision , Scale ) ] [ UNSIGNED ] [ ZEROFILL ] | DOUBLE [ ( Precision , Scale ) ] [ UNSIGNED ] [ ZEROFILL ] | DECIMAL [ ( Precision [ , Scale ] ) ] [ UNSIGNED ] [ ZEROFILL ] | NUMERIC [ ( Precision [ , Scale ] ) ] [ UNSIGNED ] [ ZEROFILL ] | DATETIME [ ( Scale ) ] | TIMESTAMP [ ( Scale ) ] | DATE | TIME [ ( Scale ) ] | YEAR | VARCHAR ( Length ) Column_charset Column_collate | VARBINARY ( Length ) | CHAR [ ( Length ) ] Column_charset Column_collate | BINARY [ ( Length ) ] | TINYTEXT Column_charset Column_collate | TINYLOB | TEXT [ ( Length ) ] Column_charset Column_collate | BLOB [ ( Length ) ] | MEDIUMTEXT Column_charset Column_collate | MEDIUMBLOB | LONGTEXT Column_charset Column_collate | LONGBLOB Precision | Scale | Length : INT _ VALUE |
The SQL property
One Two Three Four Five Six Seven Eight Nine Ten Eleven Twelve Thirteen Fourteen Fifteen Sixteen Seventeen Eighteen | Tenant_name | Pool_name | Unit_name | Zone_name | Region_name : STR_VALUE Database_name | Table_name | Table_alias_name | Column_name | Column_alias_name | Partition_name | Subpartition_name : STR_VALUE Index_name | View_name | Object_name | Constraint_name | Tablegroup_name : STR_VALUE Outline_name | User_name : STR_VALUE Table_factor : [ [ Database_name ] . ] Table_name Column_factor : [ Table_factor . ] Column _ Name |
One Two Three Four Five Six | Expression : Const_value | Column_factor | Operator_expression | Function _ Expression |
One Two Three Four Five Six | < Span Class = "Hljs-keyword" > Comment < / Span > : < Span Class = "Hljs-keyword" > COMMENT < / Span > < Span Class = "Hljs-string" > 'comment_text' < / Span > Comment_text : STR _ VALUE |
Distributed attribute
PRIMARY_ZONE : specify the master copy of data distribution strategy.
| Primary_zone : PRIMARY _ ZONE [ = ] Zone _ Name |
ZONE_LIST The specified resource distribution strategy: tenants.
| Zone_list : ZONE _ LIST [ = ] ( Zone _ Name [ , Zone _ Name . . . ] ) |
REPLICA_NUM The specified number of copies of data.
| Replica_num : REPLICA _ NUM [ = ] INT _ VALUE |
TABLEGROUP Specify multiple copies of master copy of the data distribution strategy.
One Two Three Four Five Six Seven Eight Nine Ten | Tablegroup : Default_tablegroup | Table_tablegroup Default_tablegroup : DEFAULT TABLEGROUP [ = ] { Tablegroup_name | NULL } Table_tablegroup : TABLEGROUP [ = ] { Tablegroup_name | NULL } |
The storage property
BLOCK_SIZE Micro block length of the specified object storage.
| Block_size : BLOCK _ SIZE [ = ] INT _ VALUE |
COMPRESSION The specified object storage: compression algorithm.
| Compression : COMPRESSION [ = ] { NONE | LZ4_1 . Zero | LZ0_1 . Zero | SNAPPY_1 . Zero | ZLIB_1 . Zero } |
PCTFREE Macroblock: Specifies the object storage reservation percentage.
| Pctfree : PCTFREE [ = ] INT _ VALUE |
TABLET_SIZE Minimum slice parallel merge tasks specified.
| Tablet_size : TABLET _ SIZE [ = ] INT _ VALUE |
This paper consists of Jichangxin This paper addresses the creation: Https://blog.isoyu.com/archives/tongyongyufahuizongxia.html
Use Creative Commons 4.0 The international license. In addition to indicate the transfer / origin, are the original or translation, please be sure to sign before reprint. The final edit time: July 19, 2018 at 06:46 PM
