title: how to drop partition without dropping data in MySQL?
body: <p>I have a table like:</p>
  
  <pre><code>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);
  </code></pre>
  
  <p>Not exactly like above but similar to that....</p>
  
  <p>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.</p>
  
  <p>Can any one help me to rearrange partition without dropping data or dropping table and recreating it ? </p>