The create date in show table status is metadata held in the table
itself wheras the create data on the .frm file is when that file was
created - i.e. if you copy the data files (without preserving
attributes) it will have a new creation date on the filesystem but the
metadata of the table will not change.
Andrew
-----Original Message-----
From: Jim Lyons [mailto:jlyons4435@stripped]
Sent: 05 May 2009 16:38
To: Jerry Schwartz
Cc: mysql@stripped
Subject: Re: Creation date
I would have said to look at the creation date of the .frn file, but
there
is also a field called "create date" in the "show table status" command
and
the 2 dates often differ. Anyone know why they do?
On Tue, May 5, 2009 at 9:28 AM, Jerry Schwartz
<jschwartz@stripped>wrote:
> At the risk of getting spanked for not finding this in the
documentation,
> I'm asking a simple question:
>
>
>
> Can I tell when a table was created?
>
>
>
> Regards,
>
>
>
> Jerry Schwartz
>
> The Infoshop by Global Information Incorporated
>
> 195 Farmington Ave.
>
> Farmington, CT 06032
>
>
>
> 860.674.8796 / FAX: 860.674.8341
>
>
>
> <http://www.the-infoshop.com> www.the-infoshop.com
>
>
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
