How to get Mysql Table Comments

Let’s assume that we have a table with the following table schema:

CREATE TABLE employee (         id INT NOT NULL PRIMARY KEY AUTO_INCREMENT COMMENT 'The primary key for employee',         name varchar(50) NOT NULL  COMMENT 'The name of the employee',         about TEXT NOT NULL COMMENT 'Short note about this employee' ) COMMENT='Table which holds data about employee';

Run below SQL query to see the employee table information:

SHOW FULL COLUMNS FROM employee;

The output of the preceding command will look like below shown:

Show table comments

By using the following command you can see the comment of table

SELECT table_comment FROM INFORMATION_SCHEMA.TABLES WHERE table_name='employee';

The output of the preceding command will look like below shown:

Show table column comments

By using the following command you can see the comments of each column of the given table and not the comments from the fields.

SELECT a.COLUMN_NAME, a.COLUMN_COMMENT FROM information_schema.COLUMNS a WHERE a.TABLE_NAME = 'employee';

The output of the preceding command will look like below shown:

I hope you like this Post, Please feel free to comment below, your suggestion and problems if you face - we are here to solve your problems.