Re: Table creation Time stamp

2004-10-19 Thread Heikki Tuuri
Hi! - Original Message - From: [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Wednesday, October 13, 2004 6:43 PM Subject: RE: Table creation Time stamp --=_alternative 005527E185256F2C_= Content-Type: text/plain; charset=US-ASCII By Jove! you are right! Sorry! I can't

Re: Table creation Time stamp

2004-10-13 Thread SGreen
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

Re: Table creation Time stamp

2004-10-13 Thread Michael Stassen
SHOW TABLE STATUS LIKE 'your_table_name'; See the manual for details http://dev.mysql.com/doc/mysql/en/SHOW_TABLE_STATUS.html. Michael Anil Doppalapudi wrote: 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

RE: Table creation Time stamp

2004-10-13 Thread SGreen
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