query to execute on date change

[seshu]

Hi Everybody
this is seshu here i have a doubt
How to write a query to execute on date change (do you call that a batch code or batch id i dont know what is the technical name of such a code )
some one help me out
regards
seshu

[ronverdonk]

You have 2 different question in the same thread. Therefore I have split this thread.

moderator

[ronverdonk]

You can use a CRON job (..NIX platform) if that can be setup to handle a data change (I am not so sure about that).

You cannot use MySQL 5.1 triggers because a trigger is always associated with a DATA-change statement on a single base table and not with a DATE-change.

Ronald :cool: