Track Changes

[Frank Thomson]

Hi guys,

Is it possible within mysql, to have some kind of function that monitors a table and whenever a row in that table changes, to write a copy to a second table.



Imagine the first table is a address list. If a person changes address, we make a change to the address table. This would overwrite the existing address and the old address would be lost.

BUT we might like to keep a record of peoples previous addresses.

Obviously I can do this programmatically (in my case in PHP) but it feels like something that, if it can be done within the database, makes for a much cleaner solution.

If this is possible, can you tell me how to do it or point me to somewhere that provides that information.

Thanks,