如何更改已创建的mysql中的事件 [英] How to alter an event in mysql which is already created

问题描述

任何人都可以给我语法来更改已创建的事件

Can anyone give me syntax to alter an event which has been already created

在这里我使用以下语法创建了一个事件

Here i have created an event with the following syntax

create event _insert on schedule at '2012-10-08 17:09' + interval 10 second do insert into event_test values(now());

现在我想将间隔时间从10秒更改为1分钟

and now i want to change the interval time from 10 seconds to 1minute

这是event_test表的表创建语法

Here is the table creation syntax for event_test table

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;

推荐答案

只是一个简单的alter命令?

Just a simple alter command ?

ALTER event _insert 
   ON SCHEDULE AT '2012-10-08 17:09' + INTERVAL 1 MINUTE -- or new date 
   DO INSERT INTO event_test VALUES(now());

这篇关于如何更改已创建的mysql中的事件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！