how to get the last modified time of a particular table mysql

Question

I want to know the time when my table is last modified ,whether it may insertion,deletion,update or structure change.

http://stackoverflow.com/questions/307438/how-can-i-tell-when-a-mysql-table-was-last-updated — Trying, Nov 15 '13 at 10:32

G-Man · Answer 1 · 2013-11-15T10:25:14.413

0

You can use the following query if your db uses the MyISAM storage engine

SELECT UPDATE_TIME
FROM   information_schema.tables
WHERE  TABLE_SCHEMA = 'dbname'
   AND TABLE_NAME = 'tabname'

edited Nov 15 '13 at 10:25

answered Nov 15 '13 at 09:40

G-Man

This is giving me the null..as value in my table – user2968238 Nov 15 '13 at 09:41
is your mysql db storage engine MyISAM or InnoDB ? – G-Man Nov 15 '13 at 09:43
1

yes UPDATE_TIME works for MyISAM not InnoDB – G-Man Nov 15 '13 at 10:14
Can you try SHOW table status FROM your_database WHERE name = 'your_table'; – G-Man Nov 15 '13 at 10:20
both are same SELECT UPDATE_TIME FROM information_schema.tables WHERE TABLE_SCHEMA = 'dbname' AND TABLE_NAME = 'tabname' – user2968238 Nov 15 '13 at 11:39
@GSiry yours will not at all capture the changes for innoDB. – Trying Nov 15 '13 at 18:27

1 Answers1