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> 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
