Web lists-archives.com

Re: create_time

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.trimurthy@xxxxxxxxx<mailto:skd.trimurthy@xxxxxxxxx>>
Date: Friday, May 1, 2015 at 12:15 AM
To: Martin Mueller <martinmueller@xxxxxxxxxxxxxxxx<mailto:martinmueller@xxxxxxxxxxxxxxxx>>
Cc: "mysql@xxxxxxxxxxxxxxx<mailto:mysql@xxxxxxxxxxxxxxx>" <mysql@xxxxxxxxxxxxxxx<mailto:mysql@xxxxxxxxxxxxxxx>>
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 <martinmueller@xxxxxxxxxxxxxxxx<mailto:martinmueller@xxxxxxxxxxxxxxxx>> 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

Trimurthy P
Mobile : +91 97397 64298