constant
INT_VALUE : matching integer type constants, such as One hundred and twenty-three 。 DECIMAL_VALUE Matches fixed-point type constants, such as One hundred and twenty-three point four five six 。 STR_VALUE : matching string constants, such as ABC 。 NULL Match NULL constants. STORAGE_SIZE : matching storage length constants, integer form default unit byte, string form can specify units 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 A kind of DECIMAL_VALUE A kind of STR_VALUE A kind of NULL A kind of STORAGE_SIZE STORAGE_SIZE : INT_VALUE A kind of 'INT_VALUE[M|G]' |
character set
One Two Three Four Five Six Seven Eight Nine Ten | Charset : Default_charset A kind of Column_charset Default_charset : [ DEFAULT ] { CHARSET A kind of CHARACTER SET } [ = ] { UTF8 A kind of UTF8MB4 A kind of BINARY } Column_charset : { CHARSET A kind of CHARACTER SET } { UTF8 A kind of UTF8MB4 A kind of BINARY } |
Sort rule
One Two Three Four Five Six Seven Eight Nine Ten | Collate : Default_collate A kind of Column_collate Default_collate : [ DEFAULT ] COLLATE [ = ] { UTF8MB4_GENERAL_CI A kind of UTF8MB4_BIN A kind of BINARY } Column_collate : COLLATE { UTF8MB4_GENERAL_CI A kind of UTF8MB4_BIN A kind of 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 ] A kind of SMALLINT [ ( Precision ) ] [ UNSIGNED ] [ ZEROFILL ] A kind of MEDIUMINT [ ( Precision ) ] [ UNSIGNED ] [ ZEROFILL ] A kind of INT [ ( Precision ) ] [ UNSIGNED ] [ ZEROFILL ] A kind of INTEGER [ ( Precision ) ] [ UNSIGNED ] [ ZEROFILL ] A kind of BIGINT [ ( Precision ) ] [ UNSIGNED ] [ ZEROFILL ] A kind of FLOAT [ ( Precision , Scale ) ] [ UNSIGNED ] [ ZEROFILL ] A kind of DOUBLE [ ( Precision , Scale ) ] [ UNSIGNED ] [ ZEROFILL ] A kind of DECIMAL [ ( Precision [ , Scale ] ) ] [ UNSIGNED ] [ ZEROFILL ] A kind of NUMERIC [ ( Precision [ , Scale ] ) ] [ UNSIGNED ] [ ZEROFILL ] A kind of DATETIME [ ( Scale ) ] A kind of TIMESTAMP [ ( Scale ) ] A kind of DATE A kind of TIME [ ( Scale ) ] A kind of YEAR A kind of VARCHAR ( Length ) Column_charset Column_collate A kind of VARBINARY ( Length ) A kind of CHAR [ ( Length ) ] Column_charset Column_collate A kind of BINARY [ ( Length ) ] A kind of TINYTEXT Column_charset Column_collate A kind of TINYLOB A kind of TEXT [ ( Length ) ] Column_charset Column_collate A kind of BLOB [ ( Length ) ] A kind of MEDIUMTEXT Column_charset Column_collate A kind of MEDIUMBLOB A kind of LONGTEXT Column_charset Column_collate A kind of LONGBLOB Precision A kind of Scale A kind of Length : INT A kind of VALUE |
SQL attribute
One Two Three Four Five Six Seven Eight Nine Ten Eleven Twelve Thirteen Fourteen Fifteen Sixteen Seventeen Eighteen | Tenant_name A kind of Pool_name A kind of Unit_name A kind of Zone_name A kind of Region_name : STR_VALUE Database_name A kind of Table_name A kind of Table_alias_name A kind of Column_name A kind of Column_alias_name A kind of Partition_name A kind of Subpartition_name : STR_VALUE Index_name A kind of View_name A kind of Object_name A kind of Constraint_name A kind of Tablegroup_name : STR_VALUE Outline_name A kind of User_name : STR_VALUE Table_factor : [ [ Database_name ] . ] Table_name Column_factor : [ Table_factor . ] Column A kind of Name |
One Two Three Four Five Six | Expression : Const_value A kind of Column_factor A kind of Operator_expression A kind of Function A kind of 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 A kind of VALUE |
Distributed attribute
PRIMARY_ZONE : Specifies the main replica distribution policy for data.
| Primary_zone : PRIMARY A kind of ZONE [ = ] Zone A kind of Name |
ZONE_LIST : Specifies the resource allocation strategy for tenants.
| Zone_list : ZONE A kind of LIST [ = ] ( Zone A kind of Name [ , Zone A kind of Name . . . ] ) |
REPLICA_NUM : specify the number of copies of the data.
| Replica_num : REPLICA A kind of NUM [ = ] INT A kind of VALUE |
TABLEGROUP : Specifies the main replica distribution strategy for multiple data.
One Two Three Four Five Six Seven Eight Nine Ten | Tablegroup : Default_tablegroup A kind of Table_tablegroup Default_tablegroup : DEFAULT TABLEGROUP [ = ] { Tablegroup_name A kind of NULL } Table_tablegroup : TABLEGROUP [ = ] { Tablegroup_name A kind of NULL } |
Storage attribute
BLOCK_SIZE Specifies the length of the object to store.
| Block_size : BLOCK A kind of SIZE [ = ] INT A kind of VALUE |
COMPRESSION : Specifies the compression algorithm for object storage.
| Compression : COMPRESSION [ = ] { NONE A kind of LZ4_1 . Zero A kind of LZ0_1 . Zero A kind of SNAPPY_1 . Zero A kind of ZLIB_1 . Zero } |
PCTFREE Specifies the reserved percentage of macroblock reserved for object storage.
| Pctfree : PCTFREE [ = ] INT A kind of VALUE |
TABLET_SIZE Specifies the minimum fragmentation of a single task in parallel merging.
| Tablet_size : TABLET A kind of SIZE [ = ] INT A kind of VALUE |
This article is composed of Ji Chang Xin Creation, article address: Https://blog.isoyu.com/archives/tongyongyufahuizongxia.html
Use Knowledge sharing signature 4 The international license agreement is licensed. In addition to the reprint / provenance, all originals or translations of this site must be signed before retransmission. The final editing time is April, 7, 2019 at 07:55 afternoon.
