I'm running MySQL 4.X and I want to be able to see when rows are modified. Is there a way to create a modified column in a table that gets updated with now() everytime a UPDATE or INSERT is executed? I had a case where I needed to know when a table was changed to see if a data change had caused a program to act strangely.