Name
ALTER EVENT
Synopsis
ALTER EVENT [DEFINER = {'user
'@'host
'|CURRENT_USER}]event
ON SCHEDULE ATtimestamp
[+ INTERVALcount
interval
] | EVERYcount
interval
[STARTS timestamp [+ INTERVALcount
interval
]] [ENDS timestamp [+ INTERVALcount
interval
]] [ON COMPLETION [NOT] PRESERVE] [ENABLE|DISABLE|DISABLE ON SLAVE] [COMMENT 'comment
'] DOstatement
Use this statement to alter an existing scheduled MySQL event.
The statement can be used to change the time when the scheduled SQL
statement will execute or other aspects of its upcoming execution. The
event
parameter has to be the name of an event that
was already scheduled but has not yet been completed, or was completed
but preserved by the server. It isn’t possible within MySQL to change
the name of an event. Instead, use the DROP EVENT
statement to delete an existing event and then create it again with a
new name using CREATE EVENT. You can use the SHOW CREATE EVENT statement to be sure that all other parameters
are the same.
To change the MySQL user and host through which MySQL executes
the event, use the DEFINER
clause. As of version
5.1.12 of MySQL, a user that has EVENT
privilege
can change an event. Unless the definer is specified with the
DEFINER
clause, the user that changes an event
becomes the new definer.
To change the time and date that form the basis for running the event,
use the ON SCHEDULE
AT
clause and give the new time in the timestamp
format
(yyyy-mm-dd hh:mm:ss
). The time given can be a string, a time function, or just ...
Get MySQL in a Nutshell, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.