MySQL last table alteration time

Brandon Stout bms at
Wed Mar 28 10:33:29 MDT 2007

Dave Smith wrote:

> I ended up creating a TableTimestamps table and added triggers to the 
> tables I care about to update each table's last modified time in 
> TableTimestamps. Looks to be working great. This database is mostly 
> read, with few writes, so it ought to be good performance wise too.
> --Dave

Why not just use a timestamp field on each table?  I don't think it 
violates any normalization rules, and you don't have to use a trigger:

Brandon Stout

More information about the PLUG mailing list