At 10:28 AM -0400 5/5/09, Jerry Schwartz 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?
Try
show table status
or
select table_name,create_time from information_schema.tables
that is one weird opening statement
select * from information_schema.tables where
table_name='DATABASE_NAME.TABLENAME';
Martin
May the Schwartz be with you -- Spaceballs
__
Disclaimer and Confidentiality/Verzicht und Vertraulichkeitanmerkung/Note
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.comwrote:
At the risk of
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
Thanks, I knew it had to be something simple. Now I can clean out my save
this in case you make a mistake tables.
-Original Message-
From: Steve Edberg [mailto:sbedb...@ucdavis.edu]
Sent: Tuesday, May 05, 2009 11:00 AM
To: Jerry Schwartz; mysql@lists.mysql.com
Subject: Re: Creation date