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?
Try
mysql> SHOW CREATE TABLE tablename;
(Not sure if that covers comments since I've, yes I admit it, never used comments on tables directly.)
HTH,
Robert J Taylor [EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]