mysql 分区的实现方式

```java

```php
#分区 mysql5.1 以上支持

#RANGE 范围分区

create table a (
id int PRIMARY key auto_increment,
username VARCHAR(30)
)ENGINE myisam PARTITION by RANGE (id) (
PARTITION p0 VALUES less than (5),
PARTITION p1 VALUES less than (10),
PARTITION p2 VALUES less than MAXVALUE
)

#list
create table aa (
id int PRIMARY key auto_increment,
username VARCHAR(30)
)ENGINE myisam PARTITION by list(id)(
PARTITION p0 VALUES in (1,2,3,4,5),
PARTITION p1 VALUES in (6,7,8,9,10)
)

#KEY

create table aaa (
id int PRIMARY key auto_increment,
username VARCHAR(30)
)ENGINE myisam PARTITION by key(id) PARTITIONS 3

#HASH

create table aaaa (
id int PRIMARY key auto_increment,
username VARCHAR(30)
)ENGINE myisam PARTITION by HASH(id) PARTITIONS 3