In this tutorial we are going to see how to get MySQL table comments.
Did you know that you can place comments within your SQL statements in MySQL? These comments can appear on a single line or span across multiple lines. Let’s look at how to do this.
SELECT a.COLUMN_NAME, a.COLUMN_COMMENT
FROM information_schema.COLUMNS a
WHERE a.TABLE_NAME = 'xyz';