- Date: Fri, 1 May 2015 10:45:07 +0530
- From: Pothanaboyina Trimurthy <skd.trimurthy@xxxxxxxxx>
- Subject: Re: create_time
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 <
> 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
Mobile : +91 97397 64298