NYVWeXAx

1How to alter an event in mysql which is already created
2create event _insert on schedule at '2012-10-08 17:09' + interval 10 second do insert into event_test values(now());
3	
4DROP 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;
5	
6ALTER event _insert 
7   ON SCHEDULE AT '2012-10-08 17:09' + INTERVAL 1 MINUTE -- or new date 
8   DO INSERT INTO event_test VALUES(now());