MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Pothanaboyina Trimurthy Date:May 1 2015 5:15am
Subject:Re: create_time
View as plain text  
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 <
martinmueller@stripped> 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

Thread
create_timeMartin Mueller30 Apr
  • Re: create_timePothanaboyina Trimurthy1 May
    • Re: create_timeMartin Mueller1 May
      • Re: create_timePothanaboyina Trimurthy1 May
        • Re: create_timeJohan De Meersman4 May
          • Re: create_timeJohan De Meersman4 May
            • Re: create_timeMartin Mueller4 May
              • Re: create_timeGary Armani4 May
Re: create_timeJan Steinman7 May