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
Last activity: Dec 21, 2016, 01:47 AM