Sign in to follow this  
Followers 0
Rob

SQL field: Last_Updated

2 posts in this topic

Hello,

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,

BR
Rob

Share this post


Link to post
Share on other sites

However, afaik you need MySQL 5.6 or greater for that feature

I run 5.5 and I have that table

Share this post


Link to post
Share on other sites
Advertisement
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.