daily pastebin goal
59%
SHARE
TWEET

Untitled

a guest Nov 9th, 2018 77 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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'
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top