title: How to alter an event in mysql which is already created
body: <p>Can anyone give me syntax to alter an event which has been already created </p>
  
  <p>Here i have created an event with the following syntax</p>
  
  <pre><code>create event _insert on schedule at '2012-10-08 17:09' + interval 10 second do insert into event_test values(now());
  </code></pre>
  
  <p>and now i want to change the interval time from 10 seconds to 1minute</p>
  
  <p>Here is the table creation syntax for event_test table </p>
  
  <pre><code>DROP TABLE IF EXISTS `testing`.`event_test`;CREATE TABLE  `testing`.`event_test` (`current_date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`current_date_time`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  </code></pre>