t specific table, you can just do:
SHOW TABLE STATUS LIKE 'table_name';
>
>
>
>>From: Victoria Reznichenko <[EMAIL PROTECTED]>
>>To: [EMAIL PROTECTED]
>>Subject: Re: table info
>>Date: Mon, 19 Jan 2004 14:10:37 +0200
>>
>>"
;\G
cheers,
Tobias
>
>
>
>
> >From: Victoria Reznichenko <[EMAIL PROTECTED]>
> >To: [EMAIL PROTECTED]
> >Subject: Re: table info
> >Date: Mon, 19 Jan 2004 14:10:37 +0200
> >
> >"Mike Mapsnac" <[EMAIL PROTECTED]> wrote:
> &g
> I think that main disadvantage of this command is thah it works for the
> database but not for specific table. So if a database has 200 tables, find
> result for specific table is not an easy task.
Easy:
SHOW TABLE STATUS LIKE 'table_name'
Regards, Jigal.
--
MySQL General Mailing List
For l
I think that main disadvantage of this command is thah it works for the
database but not for specific table. So if a database has 200 tables, find
result for specific table is not an easy task.
From: Victoria Reznichenko <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: table inf
"Mike Mapsnac" <[EMAIL PROTECTED]> wrote:
> Is it possible to find out when the table was created? How to get information about
> the table?
SHOW TABLE STATUS command provides info about table:
http://www.mysql.com/doc/en/SHOW_TABLE_STATUS.html
--
For technical support contracts, goto
On Sat, 17 Jan 2004, Mike Mapsnac wrote:
> Is it possible to find out when the table was created? How to get information about
> the table?
>
You can use the unix command `stat`, the last of the 4 dates will be the
creation date (in the order of Last Accessed, Last Modified, Last Inode
modificat
