Need help on mysql trigger...........

Discussion in 'MySQL' started by tamilsoft, Jun 16, 2007.

0
  1. #1
    Hi,

    Can we run a cron job from a mysql trigger?
     
    tamilsoft, Jun 16, 2007 IP
  2. ccoonen

    ccoonen Well-Known Member

    Messages:
    1,606
    Likes Received:
    71
    Best Answers:
    0
    Trophy Points:
    160
    #2
    Nope. You can however use a second "temp" table and build a cron job to hit your original table, and compare against your temp table. When it sees different, deleted, or new items, then you have your hooks, and you can then refresh the new temp table data :)
     
    ccoonen, Jun 16, 2007 IP