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]



Reply via email to