Starx Starx - 4 months ago 11
MySQL Question

Show Comment of Fields FROM Mysql Table

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?

Answer

You can use

show full columns from table

if you don't want to use information_schema

Comments