On Mon, 19 Jan 2004, Mike Mapsnac wrote: > 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.
SHOW TABLE STATUS LIKE 'tablename'\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: > > > > > 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]
