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 >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 sbedb...@ucdavis.edu >| >| Bioinformatics programming/database/sysadmin (530)754-9127 >| >+---------------- said t e lawrence, picking up his fork --------------- >-+ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org