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.