MySQL Forums
Forum List  »  Router & Proxy

Event Create
Posted by: Ashiqur Rahman
Date: June 02, 2011 01:23AM

Current Time of the system: 2011-06-02 12:05:00

I want to create event on time "2011-06-01 11:00:00". I place following sql command,

1) create event ashiq on schedule at '2011-06-01 11:00:00' do update bsp set ccrid = 'ashiq'
2) set global event_scheduler = 1

problem is, event not created. But if I provide date greater or equal to current system date then it works. How I can create event with "backdate". Please help...

Options: ReplyQuote


Subject
Views
Written By
Posted
Event Create
2552
June 02, 2011 01:23AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.