Skip to content

Instantly share code, notes, and snippets.

@apperceive

apperceive/db-table-last-access.sql

Last active October 22, 2015 13:34
Show Gist options
  • Save apperceive/80d96091452aeb98f9a6 to your computer and use it in GitHub Desktop.
Save apperceive/80d96091452aeb98f9a6 to your computer and use it in GitHub Desktop.
Download ZIP
Show mySQL database table last access dates
Raw
db-table-last-access.sql
SELECT update_time, table_name FROM information_schema.tables WHERE table_schema = 'MYDB' ORDER BY 1,2;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment