Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2010
    Posts
    8

    Unanswered: trigger an update query if that record was not update within 10 minutes

    hi,
    how can i trigger an update query on a certain record if that record was not update within last say: 1 minute???/ can i doit without using any scripting?

  2. #2
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    A trigger is something that gets executed when a record is either inserted, updated or deleted in a table. What you want to do is to schedule a process to execute periodically which looks at the records and identifies those that have not been updated within the period your are looking for. In MySQL have a look at EVENTS which allows you to schedule SQL code to scheduled within the database.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •