创建表(CREATE TABLE) DRDS支持直接连接DBProxy执行DDL语句,本文为您介绍创建数据表的DDL语句。 注意 仅V5.1.20.0.13及以后版本的实例,支持使用本文介绍的DDL语句。 语法 plaintext CREATE TABLE [IF NOT EXISTS] tablename (createdefinition, ...) [tableoption] { [partitionoption] [shardinghint] } createdefinition: columnname columndefinition {INDEX KEY} [indexname] [indextype] (keypart, ...) ... tableoption: { [ENGINE [] enginename] [CHARACTER SET [] charsetname] [COLLATE [] collationname] } partitionoption: { GLOBAL SINGLE [DN [] ‘dnname’] UDALPARTITION BY { HASH(columnname) [udalpartitionoption] HASHSTRING(columnname) [udalpartitionoption] RANGE(columnname) RANGEVALUES ‘value1[,value2...]’ } [DN [] ‘dnname[,dnname...]’] udalpartitionoption: { PARTITIONS [] number BUCKETS [] number } shardinghint: / sharding @@table name’tablename’ set type ’shardingtype’ [and { dn’dnname[,dnname...]’ shardingalgo’shardingalgo’ shardingid’columnname1’ shardingarea’columnname2’ buckets’number’ rangevalues’value1,value2...’ mapfile’enumvalue1:index1,enumvalue2:index2,...’ defaultnode’node’ startdate’startdate’ timeunittype’timeunittype’ timeunitlen’timeunitlen’ innershardingid’columnname’ innershardingalgo’shardingalgo’ innertotal’number’ innermapfile’enumvalue1:index1,enumvalue2:index2,...’ innerdefaultnode’node’ innerstartdate’startdate’ innertimeunittype’timeunittype’ innertimeunitlen’timeunitlen’ }] / shardingalgo: { mod stringmod filemap daterange enummod enumstringmod PartitionByIntRange } shardingtype: { global single inner sharding }