How I can catch event fired updating record/s in the table
Posted by: Low Coder
Date: January 28, 2011 04:05PM

Pls. advice the question. There is a table connected via ODBC to remote host. The data are updated in the table nonperiodically. It is may one change in hour or many change per second. And there is a daemon (in UNIX environment, developed in C) which must catch and handle the every events fired each such updating.
Is there in MySQL API (or third party products/solutions) the solution?
Of course I realise that best solution is trigger but it isn't much my issue. I need an event model so the endless loop approach is not much because the changings may be lost (two or more changings are possible between loops and it will make my boss very unhappy and so me too :) I want event approach as well.

Options: ReplyQuote

Written By
How I can catch event fired updating record/s in the table
January 28, 2011 04:05PM

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.