List:General Discussion« Previous MessageNext Message »
From:Steve Edberg Date:May 5 2009 3:00pm
Subject:Re: Creation date
View as plain text  
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?

	show table status
	select table_name,create_time from information_schema.tables

(information_schema only exists in MySQL >= 5.0, methinks). Manual references:

	- steve

+--------------- my people are the people of the dessert, ---------------+
| Steve Edberg                       |
| UC Davis Genome Center                            sbedberg@stripped |
| Bioinformatics programming/database/sysadmin             (530)754-9127 |
+---------------- said t e lawrence, picking up his fork ----------------+
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