How to read comments from Mysql table fields?

Question

This command

SHOW COLUMNS FROM [table name];

Shows the fields of a table and the most important details of them

I need to read the field comments, example:

COLUMN cod_id INT(10) UNSIGNED NOT NULL COMMENT 'DE CODE CLIENT'

This part I picked up in the table create code

I would need to read with "COMMENT"

Answer 1

There is a database called information_schema, that database is responsible for storing the structures of all databases.

To get the comment from a column you can select the table COLUMNS:

SELECT a.`COLUMN_COMMENT`
FROM `information_schema`.`COLUMNS` a
WHERE a.`TABLE_SCHEMA` = 'seu_banco' AND a.`TABLE_NAME` = 'sua_tabela' AND a.`COLUMN_NAME` = 'sua_coluna';

In fact, this table stores all the information in a column, not just the comment. This database is also useful for other things, such as taking all information from tables in a specific database:

SELECT * FROM `information_schema`.`TABLES` a
WHERE a.`TABLE_SCHEMA` = 'seu_banco'

Answer 2

already found the command

SHOW FULL COLUMNS FROM [TABLE];

The source: https://stackoverflow.com/questions/5404051/show-comment-of-fields-from-mysql-table