字符集

  1. charset:
  2.       default_charset
  3.     | column_charset
  5. default_charset:
  6.     [DEFAULT] {CHARSET | CHARACTER SET} [=] {UTF8 | UTF8MB4 | BINARY}
  8. column_charset:
  9.     {CHARSET | CHARACTER SET} {UTF8 | UTF8MB4 | BINARY}
  1. collate:
  2.       default_collate
  3.     | column_collate
  5. default_collate:
  6.     [DEFAULT] COLLATE [=] {UTF8MB4_GENERAL_CI | UTF8MB4_BIN | BINARY}
  8. column_collate:
  9.     COLLATE {UTF8MB4_GENERAL_CI | UTF8MB4_BIN | BINARY}

数据类型

  1. data_type:
  2.       TINYINT[(precision)] [UNSIGNED] [ZEROFILL] 
  3.     | SMALLINT[(precision)] [UNSIGNED] [ZEROFILL] 
  4.     | MEDIUMINT[(precision)] [UNSIGNED] [ZEROFILL] 
  5.     | INT[(precision)] [UNSIGNED] [ZEROFILL] 
  6.     | INTEGER[(precision)] [UNSIGNED] [ZEROFILL] 
  7.     | FLOAT[(precision, scale)] [UNSIGNED] [ZEROFILL] 
  8.     | DOUBLE[(precision, scale)] [UNSIGNED] [ZEROFILL] 
  9.     | DECIMAL[(precision [, scale])] [UNSIGNED] [ZEROFILL] 
  10.     | NUMERIC[(precision [, scale])] [UNSIGNED] [ZEROFILL] 
  11.     | DATETIME[(scale)] 
  12.     | TIMESTAMP[(scale)] 
  13.     | DATE
  14.     | TIME[(scale)] 
  15.     | YEAR
  16.     | VARCHAR(length) column_charset column_collate
  17.     | VARBINARY(length)
  18.     | CHAR[(length)] column_charset column_collate
  19.     | BINARY[(length)]
  20.     | TINYTEXT column_charset column_collate
  21.     | TINYLOB
  22.     | TEXT[(length)] column_charset column_collate
  23.     | BLOB[(length)]
  24.     | MEDIUMTEXT column_charset column_collate
  25.     | MEDIUMBLOB
  26.     | LONGTEXT column_charset column_collate
  27.     | LONGBLOB
  29. precision | scale | length:
  30.     INT_VALUE
  • 对象名
  1. tenant_name | pool_name | unit_name | zone_name | region_name:
  2.     STR_VALUE
  4. database_name | table_name | table_alias_name | column_name| column_alias_name  | partition_name | subpartition_name:
  5.     STR_VALUE
  7. index_name | view_name | object_name | constraint_name | tablegroup_name:
  8.     STR_VALUE
  12. table_factor:
  13.     [[database_name].] table_name
  15. column_factor:
  16.     [table_factor.] column_name
  • 表达式
  • 注释
  1. comment:
  2.     COMMENT 'comment_text'
  4. comment_text:
  5.     STR_VALUE

分布式属性

  • PRIMARY_ZONE：指定数据的主副本分布策略。
  1. primary_zone:
  2.     PRIMARY_ZONE [=] zone_name
  • ZONE_LIST：指定租户的资源分布策略。
  1. zone_list:
  2.     ZONE_LIST [=] (zone_name [, zone_name ...])
  • REPLICA_NUM：指定数据的副本份数。
  1. replica_num:
  2.     REPLICA_NUM [=] INT_VALUE
  • TABLEGROUP：指定多份数据的主副本分布策略。
  • BLOCK_SIZE：指定对象存储的微块长度。
  1. block_size:
  2.     BLOCK_SIZE [=] INT_VALUE
  • COMPRESSION：指定对象存储的压缩算法。
  1. compression:
  2.     COMPRESSION [=] {NONE | LZ4_1.0 | LZ0_1.0 | SNAPPY_1.0 | ZLIB_1.0}
  • PCTFREE：指定对象存储的宏块预留百分比。
  1. pctfree:
  2.     PCTFREE [=] INT_VALUE
  • TABLET_SIZE：指定并行合并时单个任务的最小分片。
  1. tablet_size: