Web lists-archives.com

Re: create_time




If you run any DDL (add column, drop column etc..) commands against
particular table then create_time will update to the latest time when the
DDL performed.

If you run any DML statements (insert,update,delete), then update_time
colum's value chages, If you restart the DB instance then update_time
columns will be set to NULL till you run the first query against that
particular table after the reboot.

On Fri, May 1, 2015 at 6:59 PM, Martin Mueller <
martinmueller@xxxxxxxxxxxxxxxx> wrote:

> 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
>
>
>
>
> --
> Thanks,
> Trimurthy P
> Mobile : +91 97397 64298
> http://mysqlinternals.blogspot.in/
> https://www.linkedin.com/pub/trimurthy-pothanaboyina/5a/9a9/96b
>



-- 
Thanks,
Trimurthy P
Mobile : +91 97397 64298
http://mysqlinternals.blogspot.in/
https://www.linkedin.com/pub/trimurthy-pothanaboyina/5a/9a9/96b