Sign in to follow this  

SQL field: Last_Updated

2 posts in this topic


it would be nice, to have a extra field in each table "Last_Updated" with type DATETIME and Standard: Current_Timestamp on Update.

I am sure it would be helpful on database management and cleanup of old items, when you can see, when a row was touched the last time.

I have implemented this and it works fine. However, afaik you need MySQL 5.6 or greater for that feature,


Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.