On Wed, May 26, 2004 at 06:22:45PM -0700, Scott Haneda wrote: > I can not find this in the docs. > > I can see in phpmyadmin what a table comment is and what type of table it > is, such as MyISAM etc. > > From the mysql shell, how do I get to this info?
You can use SHOW TABLE STATUS: http://dev.mysql.com/doc/mysql/en/SHOW_TABLE_STATUS.html Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]