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(枚舉值));
```
