Take the 2-minute tour ×
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. It's 100% free, no registration required.

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.