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?


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