Thread: Change detection in MySQL.

  1. #1
    Registered User
    Join Date
    May 2009
    Posts
    1

    Change detection in MySQL.

    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?

  2. #2
    Registered User hk_mp5kpdw's Avatar
    Join Date
    Jan 2002
    Location
    Northern Virginia/Washington DC Metropolitan Area
    Posts
    3,817
    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.

    [edit]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.[/edit]
    "Owners of dogs will have noticed that, if you provide them with food and water and shelter and affection, they will think you are god. Whereas owners of cats are compelled to realize that, if you provide them with food and water and shelter and affection, they draw the conclusion that they are gods."
    -Christopher Hitchens

  3. #3
    Officially An Architect brewbuck's Avatar
    Join Date
    Mar 2007
    Location
    Portland, OR
    Posts
    7,396
    Code:
    //try
    //{
    	if (a) do { f( b); } while(1);
    	else   do { f(!b); } while(1);
    //}

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. c++builder6 change form names problem
    By Leite33 in forum C++ Programming
    Replies: 2
    Last Post: 06-09-2008, 08:20 AM
  2. help using mysql
    By PedroTuga in forum C Programming
    Replies: 5
    Last Post: 04-20-2006, 03:04 AM
  3. Installing MySQL
    By cerin in forum Tech Board
    Replies: 2
    Last Post: 02-18-2006, 12:30 PM
  4. Replies: 2
    Last Post: 11-08-2002, 03:22 AM
  5. Replies: 2
    Last Post: 09-04-2001, 02:12 PM