random1 Posted March 4, 2010 Share Posted March 4, 2010 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. Quote Link to comment https://forums.phpfreaks.com/topic/194092-mysql-database-audit-table/ Share on other sites More sharing options...
fenway Posted March 4, 2010 Share Posted March 4, 2010 Nope -- add a "modified" column, and use magical timestamp or insert it yourself (the latter is preferable). Quote Link to comment https://forums.phpfreaks.com/topic/194092-mysql-database-audit-table/#findComment-1021460 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.