By Jove! you are right! Sorry! I can't think of an easy way to find those dates. Mr. Tuuri, any ideas?
Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Anil Doppalapudi" <[EMAIL PROTECTED]> wrote on 10/13/2004 11:04:53 AM: > i see the time stamp only for Myisam table type and not for InnoDB table > type. where can we find for Innodb Table type > > > Thanks > Anil > DBA > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 13, 2004 8:18 PM > To: Anil Doppalapudi > Cc: [EMAIL PROTECTED] > Subject: Re: Table creation Time stamp > > > use the command: SHOW TABLE STATUS > > http://dev.mysql.com/doc/mysql/en/SHOW_TABLE_STATUS.html > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > > "Anil Doppalapudi" <[EMAIL PROTECTED]> wrote on 10/13/2004 > 10:42:11 AM: > > > Hi, > > > > > > where can we find the time stamp of table creation i.e when that table > was > > created > > > > > > Thanks > > Anil > > DBA > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > >
