Bug #40740 | Unable to see creation time of databases | ||
---|---|---|---|
Submitted: | 14 Nov 2008 12:59 | Modified: | 19 Nov 2008 11:39 |
Reporter: | Johan Andersson | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Information schema | Severity: | S4 (Feature request) |
Version: | mysql-5.1-telco-7.0 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[14 Nov 2008 12:59]
Johan Andersson
[19 Nov 2008 11:39]
Hartmut Holzgraefe
The I_S.TABLES table has `CREATE_TIME` and `UPDATE_TIME` columns providing this kind of information for tables, having the same information in I_S.SCHEMATA might be nice indeed ...
[18 May 2009 14:25]
Johan Andersson
The only problem is that CREATE_TIME and UPDATE_TIME aren't set! mysql> show create table t1;; +-------+-------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+-------------------------------------------------------------------------------------------+ | t1 | CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL ) ENGINE=ndbcluster DEFAULT CHARSET=latin1 | +-------+-------------------------------------------------------------------------------------------+ mysql> select create_time, update_time from information_schema.tables where table_name='t1'; +-------------+-------------+ | create_time | update_time | +-------------+-------------+ | NULL | NULL | +-------------+-------------+ 1 row in set (0.00 sec)