If you run any DDL (add column, drop column etc..) commands against particular table then create_time will update to the latest time when the DDL performed.
If you run any DML statements (insert,update,delete), then update_time colum's value chages, If you restart the DB instance then update_time columns will be set to NULL till you run the first query against that particular table after the reboot. On Fri, May 1, 2015 at 6:59 PM, Martin Mueller < martinmuel...@northwestern.edu> wrote: > That's not quite an answer to the question I asked. Does "create_time" > represent the date at which a table was created, and does that date change > or stay the same if there is an update on the table or columns are removed > or added? > > I had an experience where a table that I knew to be several months all of > a sudden showed a create_time that was more or less identical with the > last update of the table. Which surprised me. > > From: Pothanaboyina Trimurthy <skd.trimur...@gmail.com<mailto: > skd.trimur...@gmail.com>> > Date: Friday, May 1, 2015 at 12:15 AM > To: Martin Mueller <martinmuel...@northwestern.edu<mailto: > martinmuel...@northwestern.edu>> > Cc: "mysql@lists.mysql.com<mailto:mysql@lists.mysql.com>" < > mysql@lists.mysql.com<mailto:mysql@lists.mysql.com>> > Subject: Re: create_time > > Hi Martin, > > which table are you looking at from information_schema? > > TABLES table should give you the correct information based on CREATE_TIME > column, also if you check for show table status like 'table_name'; gives > you the right information. > > On Fri, May 1, 2015 at 3:12 AM, Martin Mueller < > martinmuel...@northwestern.edu<mailto:martinmuel...@northwestern.edu>> > wrote: > I had thought that MySQL remembers the date when a table is first created > and stores it in the create_time column of Information Schema. But this > doesn¹t seem to be the case.On my machine it seems to record the date of > most recent access. Which seems odd. > > Am I doing something wrong? Is there a way of finding the date when a > table was first created? > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql > > > > > -- > Thanks, > Trimurthy P > Mobile : +91 97397 64298 > http://mysqlinternals.blogspot.in/ > https://www.linkedin.com/pub/trimurthy-pothanaboyina/5a/9a9/96b > -- Thanks, Trimurthy P Mobile : +91 97397 64298 http://mysqlinternals.blogspot.in/ https://www.linkedin.com/pub/trimurthy-pothanaboyina/5a/9a9/96b
