SHARE
TWEET

Untitled

a guest Sep 17th, 2014 248 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. mysql> SELECT now();
  2. +---------------------+
  3. | now()               |
  4. +---------------------+
  5. | 2014-09-17 10:44:53 |
  6. +---------------------+
  7. 1 row in set (0.00 sec)
  8.  
  9. mysql> insert into event (name) values ('test');
  10. Query OK, 1 row affected (0.00 sec)
  11.  
  12. mysql> SELECT * FROM (     SELECT         table_name,         IFNULL(update_time,create_time) LastTimeTouched     FROM         information_schema.tables     WHERE         table_name = 'event' AND table_schema='test') A ORDER BY LastTimeTouched LIMIT 20;
  13. +------------+---------------------+
  14. | table_name | LastTimeTouched     |
  15. +------------+---------------------+
  16. | event      | 2014-09-16 08:27:41 |
  17. +------------+---------------------+
  18. 1 row in set (0.00 sec)
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