Guest User

Untitled

a guest
Nov 9th, 2018
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.27 KB | None | 0 0
  1. SELECT update_time FROM information_schema.tables WHERE table_name='yourtablename'
  2.  
  3. SELECT table_schema ,
  4. table_name,
  5. update_time as LastAccessed
  6. FROM information_schema.tables
  7. GROUP BY table_schema
  8. ORDER BY update_time ASC
  9.  
  10. WHERE update_time < 'yyyy-mm-dd'
Add Comment
Please, Sign In to add comment