How can I access the table comment from a mysql table?

Based on the answer by OMG Ponies, but using INFORMATION_SCHEMA.TABLES instead of INFORMATION_SCHEMA.COLUMNS. When looking around on the web, all I could find was info on the columns’ comments, but never on the table’s. This is how to get a table’s comment.

SELECT table_comment 
    FROM INFORMATION_SCHEMA.TABLES 
    WHERE table_schema="my_cool_database" 
        AND table_name="user_skill";
+--------------------------+
| table_comment            |
+--------------------------+
| my awesome comment       | 
+--------------------------+

Leave a Comment

tech