mysql怎么删除数据组,如何删除分区而不删除MySQL中的数据？

I have a table like:

create table registrations(

id int not null auto_increment primary key,

name varchar(50),

mobile_number varchar(13))

engine=innodb

partition by range(id) (

partition p0 values less than (10000),

partition p0 values less than (20000),

partition p0 values less than max value);

Not exactly like above but similar to that....

Now assume that my table has 200000 rows and now I want to remove partitions on the table and reorganize them in accordance to requirement without MAX VALUE in it.

Can any one help me to rearrange partition without dropping data or dropping table and recreating it ?

解决方案ALTER TABLE tbl REMOVE PARTITIONING;