[SOLVED] Show Comment of Fields FROM Mysql Table

Issue

SHOW COLUMNS FROM <tablename> gives all the information of the columns in a table, except Comments.

How to extract Comments information? I know the way to extract the information from INFORMATION SCHEMA, but how to combine the result in a single result set?

Solution

You can use the query

SHOW FULL COLUMNS FROM <tablename>

If you don’t want to use information_schema.

Answered By – Nicola Cossu

Answer Checked By – Mildred Charles (BugsFixing Admin)

Leave a Reply

Your email address will not be published.