MySQL last table alteration time
smorrey at gmail.com
Tue Mar 27 16:18:07 MDT 2007
I don't believe a table has any concept of a time unless one of 2
things is present.
#1 A timestamp field is appended to the table
#2 Logging is enabled.
If #2 is true you don't actually query the table, you query the log.
If #1 is true then you can set the timestamp field to update
automatically each time there is an update or insert command (using a
trigger, although IIRC this should be an automatic trigger)
On 3/27/07, Dave Smith <dave at thesmithfam.org> wrote:
> Does MySQL provide a way to query the last time a table's data was
> changed (i.e., insert, delete, or update)? Preferably, I'd like to
> execute an SQL statement to get the information. I realize I could go
> look at the .frm files on disk, but I may not have local access to the
> MySQL server.
> PLUG: http://plug.org, #utah on irc.freenode.net
> Unsubscribe: http://plug.org/mailman/options/plug
> Don't fear the penguin.
More information about the PLUG