Creation time of Innodb tables

Posted by shantanuo on Stack Overflow See other posts from Stack Overflow or by shantanuo
Published on 2010-03-26T05:13:20Z Indexed on 2010/03/26 5:23 UTC
Read the original article Hit count: 344

Filed under:

CRETAE_TIME column of "TABLES" table from INFORMATION_SCHEMA shows the same CREATE_TIME for all my innodb tables. It means all these tables were created between 2010-03-26 06:52:00 and 2010-03-26 06:53:00 while actually they were created a few months ago.

Does the CREATE_TABLE field change automatically for Innodb tables?

© Stack Overflow or respective owner

Related posts about mysql