mysql事件晚上12点执行,Mysql事件执行开始时间

I have one mysql event which will execute every 1 day and do some activity. Please find code snippets for the same.

delimiter |

CREATE EVENT createTest

ON SCHEDULE EVERY 1 DAY

DO

BEGIN

-- Do some work

END |

delimiter ;

when i created this event it executes same time for the same day. For next day it executes (last execution + 24 Hour) scenario.

is it possible to set start time in events? I want to executes this events on every day 0 hour?

解决方案

Yes, you can do it. Use STARTS option for this purpose.

CREATE EVENT event1

ON SCHEDULE EVERY '1' DAY

STARTS '2012-10-03 00:00:00'

DO

BEGIN

-- do something

END

Note, that event start datetime must be in a future.

For @spt -

CREATE EVENT event1

ON SCHEDULE EVERY '1' YEAR

STARTS '2016-04-01 00:00:00'

DO

BEGIN

END

Also, if it is hard to create and setup event object, you can use GUI event object editor in dbForge Studio for MySQL (free Express edition allows it).