The method of viewing field comments by mysql

This article will explain in detail the method of viewing field notes on mysql. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

Mysql can view the comments of a field by executing the [show full columns from table.A;] statement directly.

1. Check the table and field remarks at a time

Show full columns from table.A

2. View the entire database to view all table names, table comments, field names, field types, and field comments in the database

Select t.TABLE_NAME, t.TABLE_COMMENT, c.COLUMN_NAME, c.COLUMN_TYPE, c.COLUMN_COMMENT from information_ schema.`COLUMNS`c Information_ schema.`TABLES`t where c.TABLE_NAME = t.TABLE_NAMEand t.TABLE_SCHEMA = 'database'-change to the name of the database you queried This is the end of the method of viewing field notes for mysql. I hope the above content can be helpful to you and learn more knowledge. If you think the article is good, you can share it for more people to see.