question

chetan avatar image
chetan asked

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.
mysql
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.