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:

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.

Arjun
I am Arjun from Hyderabad (India). I have been working as a software engineer from last 7+ years, and its my passion to learn new things and implement them as a practice. Aside from work, I likes gardening and spending time with pets.
DMCA.com Protection Status