Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> SELECT now();
- +---------------------+
- | now() |
- +---------------------+
- | 2014-09-17 10:44:53 |
- +---------------------+
- 1 row in set (0.00 sec)
- mysql> insert into event (name) values ('test');
- Query OK, 1 row affected (0.00 sec)
- 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;
- +------------+---------------------+
- | table_name | LastTimeTouched |
- +------------+---------------------+
- | event | 2014-09-16 08:27:41 |
- +------------+---------------------+
- 1 row in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement