Create Event Schedular to update record in database in MySQL

Last Reply 12 days ago By dharmendr

Posted 12 days ago

i have set the event yesterday i.e. on 2018-04-09 01:52:59 to update the status automatically.

so my question is when it will going to update the status?

Is status will update on 2018-04-10 01:52:59?

CREATE EVENT ProposalAbort ON SCHEDULE EVERY 1 day DO
update barter_proposals 
       set proposal_status="Aborted"
     WHERE sent_date=DATE(CURDATE()-INTERVAL 1 DAY)
       AND proposal_status = "Sent/Received"

i have set the event yesterday at this time(2018-04-09 01:52:59 ) which automatically update the status to "Aborted".i set the 1 day interval as shown in event query.

so i wanted to know whent it will change status to "Aborted" from "Sent/Received".is it today at 01:52:59?

You are viewing reply posted by: dharmendr 12 days ago.
Posted 12 days ago

Yes. The same time. For more details refer below link.

https://dev.mysql.com/doc/refman/5.7/en/create-event.html

 

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html