create table 表名(
`id` int(11) auto_increment,
`name` varchar(50),
`birthday` date,
primary key(`id`,`birthday`) //复合索引
)engine=myisam charset=utf8
partition by range (month(birthday))( //可以是年
partition p1 values less than (3),
partition p2 values less than (6),
partition p3 values less than (9),
partition p4 values less than MAXVALUE
);
less than 小于等于时候
MAXVAUE 可能的最大值