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:sbedberg@stripped]
>Sent: Tuesday, May 05, 2009 11:00 AM
>To: Jerry Schwartz; mysql@stripped
>Subject: Re: Creation date
>
>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
>
>(information_schema only exists in MySQL >= 5.0, methinks). Manual
>references:
>
> http://dev.mysql.com/doc/refman/5.0/en/show-table-status.html
>
> http://dev.mysql.com/doc/refman/5.0/en/information-schema.html
>
>
> - steve
>
>--
>+--------------- my people are the people of the dessert, --------------
>-+
>| Steve Edberg http://pgfsun.ucdavis.edu/
>|
>| UC Davis Genome Center sbedberg@stripped
>|
>| Bioinformatics programming/database/sysadmin (530)754-9127
>|
>+---------------- said t e lawrence, picking up his fork ---------------
>-+
