Re: table info

[Mike Mapsnac]

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 info
Date: Mon, 19 Jan 2004 14:10:37 +0200
"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 https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]
_________________________________________________________________
Rethink your business approach for the new year with the helpful tips here. 
http://special.msn.com/bcentral/prep04.armx

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]