List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:May 5 2009 4:39pm
Subject:RE: Creation date
View as plain text  
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 ---------------
>-+



Thread
Creation dateJerry Schwartz5 May
  • Re: Creation dateSteve Edberg5 May
    • RE: Creation dateJerry Schwartz5 May
  • RE: Creation dateMartin Gainty5 May
  • Re: Creation dateJim Lyons5 May
    • RE: Creation dateAndrew Braithwaite5 May