Changes to database tables

Giganews Newsgroups
Subject: Changes to database tables
Posted by:  luisdev (andy…
Date: Thu, 18 Aug 2011

I'm "analysing" an open source web application to understand how it
works so that I can contribute some code to it. When I want to see
what database records are added, removed and/or changed by a function
in the
application I just run a SELECT * FROM SOMETABLE before and after
running the function. Then I compare the two results of that SELECT
and I can see the changes to the data.

But is there a better way?

And is there a way to determine which tables have had records added,
removed and/or changed when I do something in the application?