Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

As I am quite new to server side, I tried to create a event using

CREATE EVENT enetname ON SCHEDULE AT '2013-06-13 18:00:00'+INTERVAL 30 SECOND DO update tablname set status= 'Expired' where expirydate < CURDATE();

This event is creating updsting the field till the time the mysql cmdprompt is open.

When I am closing the command prompt the event gets dropped/expired, where as my event scheduler is running and waiting fr next activation.

Please tell me how to avoid the dropping of event.

share|improve this question
    
It doesn't look like a recurring event. Have you tried with EVERY ... : dev.mysql.com/doc/refman/5.5/en/create-event.html – ypercubeᵀᴹ Jun 13 '13 at 13:23
    
since i am using interval 30, should i need to use Every – Subrat nayak. Jun 13 '13 at 14:21

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.