Shulou(Shulou.com)06/01 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.