Advertisement
Guest User

Untitled

a guest
Sep 17th, 2014
348
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.71 KB | None | 0 0
  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)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement