Query for date latest db-edit

[Anon]

Hi,

I'd like to know if there's any code available that makes it possible to find out when my MySQL database was updated for the last time. I don't like to add an extra row in my tables wich contains a date-field. Hope somebody out there understands what I'm talking about and knows an answer... Please submit!
Keep up the good work...

Tom

[bouche]

Who not just do a :
SELECT whatever FROM whereever ORDER BY datefield DESC LIMIT 1
: and do a check on that in your php-script......?? if the datefield contains the date the row was created (timestamp)

[Anon]

Yeah, but this way I need to add an extra row to my table. That's not what I'm looking for. Thanks anyway!
Any other suggestions? Please submit!

Tom

[[deleted]]

You can only "reliably" do that if your table contains a timestamp field. Note the use of the word TIMESTAMP, not a date-type or datetime.

TIMESTAMP columns are updated automatically when a record is inserted or updated.

Then you can select max(timestamp_field) to get the latest update date.

Don't use this to find a record you just inserted, because this is not multi-user safe.