"Martijn Tonies" <m.tonies@stripped> wrote:
>> > > If your table contains a timestamp field, it will update each time the
>> > > 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?
Build an index on this column and force it:
SELECT MAX(timestamp) FROM table FORCE INDEX(timestamp_index)
In this case you'll be sure that it's fast enough.
And, of course, as Ian Gibbons correcly mentioned, you can use MySQL-only way
to check the latest update time of a table:
SHOW TABLE STATUS LIKE 'tablename';
and look for the Update_time field.
> Martijn Tonies
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ Egor.Egorov@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net