MySQL Forums
Forum List  »  Events (Job Scheduler)

Re: Setting up an Event to wake up when a columns timestamp matches the system time
Posted by: Roel Van de Paar
Date: August 13, 2009 07:35PM

Have you consider using triggers?

'A trigger is defined to activate when an INSERT, DELETE, or UPDATE statement executes for the associated table. A trigger can be set to activate either before or after the triggering statement. For example, you can have a trigger activate before each row that is inserted into a table or after each row that is updated.'

Further details:
http://dev.mysql.com/doc/refman/5.0/en/triggers.html
http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Setting up an Event to wake up when a columns timestamp matches the system time
2854
August 13, 2009 07:35PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.