From: Martijn Tonies
Date: June 10 2004 12:02pm
Subject: Re: Last Modified
List-Archive: http://lists.mysql.com/mysql/167059
Message-Id: <01d201c44ee2$cb40bf10$0a02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit


> > Mind you -- 
> >
> > > If your table contains a timestamp field, it will update each time the
> row
> > > is altered.  Otherwise I don't think it's possible.
> >
> > That's on a per ROW basis, not TABLE basis.
>
> But if it is on every row, you can MAX() it to get the latest row update,
> which is the latest table update.


How fast would this be on a largish table?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com