1.查询mysql是否支持分区
```
show variables like '%partition%';
```
**range分区**
```
partition by range (列名)(
partition p0 values less than (数字),
partition p1 values less han maxvalue
)
```
**list分区**
```
partition by list columns(列名)(
partition p0 values less than (枚举值),
partition p1 values less han (枚举值)
```
**hash分区**
```
partition by hash(列名)
partition 4;多少个分区
```
**key分区**
```
partition by linear key (列名)
partition 3;分多少个区
```
2.删除分区
```
after table 表名 drop partition 分区名字;
```
3.添加分区
```
after table 表名 add partition(partition 分区名称 values in(枚举值));
```