From: Christian Mack Date: March 17 1999 3:11pm Subject: Re: Last Modification of Table/Database (fwd) List-Archive: http://lists.mysql.com/mysql/429 Message-Id: <36EFC639.48DB87F7@compal.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit J Yunke wrote: > > Hi -- > > Quick question here. I know that individual rows can be timestamped > with a TIMESTAMP-based field. > > Is there a way one can find out when the last time a table (or database) > has been modified in any way? > > /J > > -- > > Justin Yunke + yunke@stripped Hi Justin The soon coming 3.23.xx version will have such feature for tables. In the moment you only can do something like: SELECT MAX(timestamp_field) FROM table Tschau Christian