PDA

View Full Version : Change detection in MySQL.



amitbora27
05-13-2009, 07:06 AM
Hi,

I am trying to build a application in which I can be able to flow data to MySQL and vice -versa.

I need to understand that how the update, any changes done in MySQL database will be known or immediately flown to other side?

What is the Change detection mechanism in MySQL?

What I am trying to understood is :
If I add some entry in Database it has immediately flown to other side.


Need to find out the all different changes (add, delete, modify, rename) done on number of tables.


Do we have any MySQL API which accepts some parameter and internally execute the command to return the changes?

Can you please shed some light on this?

hk_mp5kpdw
05-13-2009, 07:56 AM
Flown to other side? Changes to the database are made permanent once you commit those changes. Commits can happen explicitly or implicitly.

Database triggers can be used to log inserts/deletes/updates to a given table; alternately if you're doing this through an application, then it should be able to keep a log of changes made to tables.

Stored procedures in the database can be created and then called in your application which accept parameters and return values.

Any of the above is based on my experience with Oracle, not MySQL. I'm guessing they should be similar enough that the principles still apply.

brewbuck
05-13-2009, 10:34 AM
MySQL :: MySQL 5.0 Reference Manual :: 18.3 Using Triggers (http://dev.mysql.com/doc/refman/5.0/en/triggers.html)