MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Christian Mack Date:March 17 1999 3:11pm
Subject:Re: Last Modification of Table/Database (fwd)
View as plain text  
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


Last Modification of Table/Database (fwd)J Yunke17 Mar
  • Re: Last Modification of Table/Database (fwd)Christian Mack17 Mar