how to update the status automatically after 15 days?
i have a status and sent_date.i wanted to change the status after 15 days automatically. suppose sent_date is 23/3/2018 and status is "Sent/Received" So after 15 days ,status should change to "Aborted" automatically..How to do it? i have used the concept event schedular. CREATE EVENT reset ON SCHEDULE EVERY 15 Day DO update barter_proposals set proposal_status="Aborted" WHERE DATE_ADD( sent_date, INTERVAL 15 Day ) AND proposal_status = "Sent/Received" Any changes are required?Any help will be highly appreciated.