File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Trigger runs on some column time reached...

 
kavin clain
Ranch Hand
Posts: 68
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 423
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 68
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic