Hi

I have a database in mysql with a series of linked tables one of which as the following columns

Id; Datejoined; D.O.B; duration; Age. The last two columns are calculated based upon the first two respectively.

I would like to know if it is possible to update these calculated columns automatically everytime I view the table. At the moment I have to recalculate each row individually to keep these upto date.

I hope somebody can help either through SQL or a script.


Grabro

Sounds like you have two distinct issues here.

1. Updating the records.
2. Displaying the records.

Are you looking to update all the records automatically, or just update the particular ones when you want to view them?

Centinul

::EDIT:: Additionally how do you define age? Do you want it in just years or years, days, months, minutes, seconds?

Centinul

Displaying the record is not a problem except that when they are displayed the duration and age columns will still show the years when that particular record was entered or specifcally updated.

I can update each record individually to amend these columns but I would rather not as there is a lot of them.

These columns only have the number of years in them so soem would changing and some wouldn't.

I am not aware that the usual UPdate function will work on a calculeted field or will only work
by adding a specific thing e.g. Age +1 to increase age by one.

Grabro

So are you looking for a way to batch update the records or a way to update the records dynamically when a user views them?

Thanks,

Centinul