Categories
PHP / MySQL

How to get Mysql Table Comments

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

Run below SQL query to see the employee table information:

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

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.

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

By Arjun

I am Arjun from Hyderabad (India). I have been working as a software engineer from the last 7+ years, and it is my passion to learn new things and implement them as a practice. Aside from work, I like gardening and spending time with pets.

Leave a Reply

Your email address will not be published. Required fields are marked *