create event myevent on schedule every 1 day
starts current_timestamp
ends current_timestamp+interval 1day
do call f()在一天以后执行用at怎么写?我写的
create event myevent at current_timestamp+interval 1day
do call f()
报错了
大家帮帮忙,第一次用这个
starts current_timestamp
ends current_timestamp+interval 1day
do call f()在一天以后执行用at怎么写?我写的
create event myevent at current_timestamp+interval 1day
do call f()
报错了
大家帮帮忙,第一次用这个
CREATE EVENT myevent
ON SCHEDULE
EVERY 1 day STARTS '2010-02-05 17:51:21' ENDS '2010-02-06 17:51:21'
DO
call f();
这样行不行?
ON SCHEDULE AT '2010-02-06 17:51:21'
DO
call f();