MySQL Forums
Forum List  »  Newbie

Track Changes
Posted by: Frank Thomson
Date: January 05, 2022 04:27PM

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,

Options: ReplyQuote


Subject
Written By
Posted
Track Changes
January 05, 2022 04:27PM
January 05, 2022 05:13PM
January 06, 2022 02:08PM


Sorry, only registered users may post in this forum.

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.