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
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
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
wrote:
> At the risk of getting spanked for not
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
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
