MySQL Database Audit Table?

[random1]

Hi All,

 

Does MySQL have an automatic auditing functionality?

 

i.e. Do I have to create an audit table that stores the date and time a record/field was last updated?

 

OR does Mysql have a way of asking it "When was record '1' in table 'a' last updated (edited)?

 

e.g. maybe something like "SELECT LAST UPDATED table_name(1);" ?

 

The datetime format im using is UTC.

[fenway]

Nope -- add a "modified" column, and use magical timestamp or insert it yourself (the latter is preferable).