Skip to content
Skip to breadcrumbs
Skip to header menu
Skip to action menu
Skip to quick search

Welcome to FreeSoftwareServers Confluence Wiki

Skip to end of banner Go to start of banner

Find Last Update Time for MySQL Table

Skip to end of metadata

Created by FreeSoftwareServers, last modified on Jan 17, 2017

Go to start of metadata

For Specific Table

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

For All Tables in DB:

SELECT UPDATE_TIME
FROM   information_schema.tables
WHERE  TABLE_SCHEMA = 'dbname';

No labels

1 Comment

Anonymous
- Permalink
- Dec 06, 2018
- Delete comments

This site is just a tech blog, nothing is guaranteed!