I need info

[jintot]

is it possible that mysql update the record automatically in such time?

 

for example,

 

|    balance  |    maturity_date        |

------------------------------------

|  12000      | 2008-02-19 20:00:00 |

 

 

if the maturity that date comes, the balance increase by 6% automatically..

 

i dont have any query on it because i don't know if it is possible..

 

thanks! 

[weasel2006]

Hi there,

 

I'm only a beginner myself but maybe something like this could be done with cron?

Have the cron call and run a script that goes through the database and finds the column with the values you want increasing and have the script run an equasion to add X% to whatever it finds in each field in that column and returns the new value to the field, processing each field / cell in that column in turn.

Then have the script run by cron once every 24 hours maybe?

 

Of course the script would need some way of telling what had matured and what hadn't!

 

As I say, I'm a noob and there is probably a better and more efficient way to do this.

 

If it's not feesable it was a good idea lol

 

Just trying to help 

[jintot]

hey dude! thanks for the idea.. maybe ill try to search for cron...

 

maybe other experts may share other ideas regarding my question.. thanks!! cheers!!

[jintot]

by the way, i'm using windows xp OS.. thanks!!

[fenway]

Yes, a cron is likely the best way to go... otherwise, maybe the event scheduler in 5.1, but I haven't used it.

[jintot]

i think cron is for unix like OS only? i have read something about it but the case is, im using windows xp.. what will be the tool that i might use? thanks!! 

[fenway]

i think cron is for unix like OS only? i have read something about it but the case is, im using windows xp.. what will be the tool that i might use? thanks!! 

There is an AT scheduler.