1、范围分区 range
create table table_name()
partition by range(分区列)
(
partition 分区1 values less than (值1),
partition 分区2 values less than (值2),
...
partition 分区n values less than (maxvalue)
)
2、列表分区 list
create table table_name()
partition by list (列)
(
partition 分区1 values(列值1),
partition 分区2 values(列值2),
...
)
3、散列分区 hash
create table table_name()
partition by hash(列名)
(
partition 分区名1,
partition 分区名2,
...
)