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:jlyons4...@gmail.com] Sent: 05 May 2009 16:38 To: Jerry Schwartz Cc: mysql@lists.mysql.com 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 <jschwa...@the-infoshop.com>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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
