Auto preform command

[ljmks2]

Is there a way to preform action which is not triggered by user event (such as click?).

I'd like MySQL database to delete some entries after they are older than 1 month (let's say).

Thanks for your time...

Roger&out

[Anon]

hello there is no such concept of triggers in mysql --

and i hope ur question is not clear

please mail in detail at [e-mail]

i will try to help u out

mandar

[terje-s]

This has (sort of anyway) been discussed a number of times before. Please search the forums for info on 'crontab' and such.

However, mysql does not (that I know of, I'm not activly watching) have triggers like postgresql. Using a trigger you could make the db itself call a script whenever an entry outdates or whatever. This is (like I said, to my knowledge) not possible in mysql. You have to write a script outside of mysql and launch it using other programs (crontab is nice).