create table 表名(
`id` int auto_increment,
`name` varchar(50),
`birthday` date
primary key(`id`,`birthday`)
)engine=myisam charset=utf8
partition by hash(month(birthdy)) partitions 12; //将区域分为12区,(自己定)
取余放入文件
create table 表名(
`id` int auto_increment,
`name` varchar(50),
`birthday` date
primary key(`id`,`birthday`)
)engine=myisam charset=utf8
partition by hash(month(birthdy)) partitions 12; //将区域分为12区,(自己定)
取余放入文件