title: using interval partitioning in mysql
body: <p>I'm trying to learn <code>MYSQL</code> with the knowledge I learn from <code>Microsoft Sql</code> and <code>Oracle</code>. I'm trying to use interval partitioning on a table but I'm not seeing the solution for the error I'm having.</p>
  
  <pre><code>create table telmar_php.call_log
  (
   log_id int not null,
   sender int,
   reciever varchar(30) not null,
   call_duration TIMESTAMP,
   call_start TIMESTAMP,
   call_end TIMESTAMP,
   primary key (log_id),
   foreign key(sender) references number_assigned(sender)
  )
  partition by RANGE (call_duration) //This is the error line
  INTERVAL(NUMTODSINTERVAL(1, 'HOUR')) 
  (PARTITION "2015-03-15 00:00:00" VALUES LESS THAN (TO_DATE ('2015-03-16 00', 'YYYY-MM-DD hh24', 'NLS_CALENDAR=GREGORIAN')));
  </code></pre>
  
  <p>that's the code is that you can't use interval partitioning in MYSQL? </p>