Sample Header Ad - 728x90

Get the Time of Last update of a column

10 votes
2 answers
48293 views
This command gives the date of the last update for a table SELECT UPDATE_TIME FROM information_schema.tables WHERE TABLE_SCHEMA = 'MyDB' AND TABLE_NAME = 'MyTable' But I want to find the time of last update of a particular column of a table. I can't use triggers because I want to know the time of last update of a specific column from a system table. I hope I explained well my problem.
Asked by dardar.moh (275 rep)
Jun 29, 2013, 10:41 PM
Last activity: Dec 21, 2016, 01:47 AM