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
