MySQL Forums
Forum List  »  Security

How can find the Changes in Database Table Structure
Posted by: Karthikeyan T
Date: August 31, 2015 05:16AM

Dear Forum Members,
I need know some information about the information_schema Database, i using 5.5.42-cll in Linux platform,I am using InnoDb engine for my database.I noticed that CREATE_TIME field of TABLES table in information_schema database have being updated for every changes made in concern base table structure.I created table in own database in different date and time for example 2015-08-20 12:08:12,2015-08-18 17:45:06 respectively. There after I did not made any changes in concern table's structure , again I checked the CREATE_TIME field for all tables have been changed as "2015-08-29 00:57:23". I have to know that there is any possibility for updation of CREATE_TIME field value in `information_schema`.`TABLES` table while try restart the MySQL Server instance by the system itself?

Options: ReplyQuote

Written By
How can find the Changes in Database Table Structure
August 31, 2015 05:16AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.