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 <[EMAIL PROTECTED]> 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. --Dave /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
/* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
