File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Trigger runs on some column time reached... Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Trigger runs on some column time reached..." Watch "Trigger runs on some column time reached..." New topic
Author

Trigger runs on some column time reached...

kavin clain
Ranch Hand

Joined: Jan 19, 2010
Posts: 68
I am new to SQL queries and currently using MySQL.

In one of my database table, there is a column contains value of type timestamp.
Is it possible to set a trigger which will run when that time is reached?
Ireneusz Kordal
Ranch Hand

Joined: Jun 21, 2008
Posts: 423
Triggers are generally executed on some events, primarily on inserting/deleting/updating tables or records.
Something must first fire an event to the trigger to be executed.
You can use a job scheduler to execute an action at a given time.
Here is an article how to schedule jobs in MySql 5.1:
http://dev.mysql.com/tech-resources/articles/mysql-events.html
kavin clain
Ranch Hand

Joined: Jan 19, 2010
Posts: 68
Thanks for help.

There can be any number of such records to check for schedule match, and if it checks every few seconds then I want to know , would it affect the performance?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Trigger runs on some column time reached...