drop table if exists `a`; create table `a`(`a30` int not null )engine=myisam; alter table `a` partition by key(`a30`) partitions 1; alter table `a` add partition partitions 3;