Update database table particular column of specific row automatically

Question

I need to make some real time updates on database without user interactions. I have columns as below

ID
Flight_Departure_Time
Flight_Arrival_Time
Status

User previously updates database as they can update Flight_Departure_Time & Flight_Arrival_Time . Now If arrival_time matches with current time it should automatically update status = Arrived at destination

How can I achieve this using mySQL?

score 0 · Answer 1 · edited May 23 '17 at 12:32

0

You have to run a cron Job or scheduled task to update the table in every 1 or 5 or 10 or 15 minute interval of time.

note that the latest update will get only after the given minutes.

Using crontab to execute script every minute and another every 24 hours

edited May 23 '17 at 12:32

Community

1
1

answered Aug 30 '16 at 06:21

safin chacko

1,332
1
10
18

Update database table particular column of specific row automatically

1 Answers1