I have reservation table(MySQL) and the schema is (id, status, checkin_date, checkout_date)
What I want is automatically update status when today is the checkin_date
What will be the best way to do this?
Asked
Active
Viewed 36 times
-1
-
As far as I know for this type of tasks you should to use a job scheduler like Cron on your web server. – Vetos May 07 '22 at 10:01
-
Check [Event Scheduler](https://dev.mysql.com/doc/refman/8.0/en/event-scheduler.html) – Ergest Basha May 07 '22 at 10:54