Display Table or Column Comments

[DawG]

Does anyone know how to display the Table and Column comments in mySQL?

I see the phpMyAdmin does it and it would be extremely useful in my current application. Unfortunately, searching for comments on the web returns garbage in this case.

[jmucchiello]

Have you tried the mySQL documentation:

http://dev.mysql.com/doc/refman/4.1/en/show.html

SHOW FULL COLUMNS FROM tablename
and
SHOW TABLE STATUS LIKE 'tablename'
look promising. But I haven't tried this from the server.