MySQL/GreatDB 创建分区表、联合主键、联合索引、唯一索引、普通索引

本文主要是介绍MySQL/GreatDB 创建分区表、联合主键、联合索引、唯一索引、普通索引，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

# list分区 、联合主键、联合索引、唯一索引、普通索引
drop table par_list;
create table par_list(t_id int comment '序列',t_name varchar(10) comment '姓名',t_score float,t_part date,t_sex int ,t_Upper char,t_uuid varchar(300)comment '唯一识别码',primary key pri_lh(t_id,t_name),unique u_two_pri(t_uuid,t_id) comment '唯一索引',index (t_part)
) comment '联合主键' partition by list(t_id)
(partition p0 values in(1,2,3),partition p1 values in(4,5,6));# range分区
drop  table  par_range;
CREATE TABLE par_range (id INT NOT NULL ,fname VARCHAR (30),lname VARCHAR (30),hired DATE NOT NULL DEFAULT '1970-01-01' ,separated DATE NOT NULL DEFAULT '9999-12-31' ,job_code INT NOT NULL ,store_id INT NOT NULL
)
PARTITION BY RANGE (store_id) (PARTITION p0 VALUES LESS THAN (6),PARTITION p1 VALUES LESS THAN (11),PARTITION p2 VALUES LESS THAN (16),PARTITION p3 VALUES LESS THAN MAXVALUE
);# hash分区
drop table par_hash;
CREATE TABLE par_hash (id INT NOT NULL ,fname VARCHAR (30),lname VARCHAR (30),hired DATE NOT NULL DEFAULT '1970-01-01' ,separated DATE NOT NULL DEFAULT '9999-12-31' ,job_code INT ,store_id INT
)
PARTITION BY HASH( YEAR (hired))
PARTITIONS 4;# key分区
drop table  par_key;
CREATE TABLE par_key (col1 INT NOT NULL ,col2 CHAR (5),col3 DATE
)
PARTITION BY  KEY (col1)
PARTITIONS 3;