MySQL last table alteration time

Brandon Stout bms at mscis.org
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:

  http://dev.mysql.com/doc/refman/5.0/en/timestamp-4-1.html

Brandon Stout
http://mscis.org



More information about the PLUG mailing list