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

Editor to share with you the method of mysql to view field comments, I hope you will learn a lot after reading this article, let's discuss it together!

Mysql can view field comments by executing the [show full columns from test] command. If we want to view the comments on the data table, we can execute the [show create table test] command.

The specific methods are as follows:

Write comments when you create a table

Create table test1 (comments for field_name int comment 'field') comments for the comment=' table'

Modify the comments of the table

Alter table test1 comment 'comments on modified tables'

Modify the comments of the field

Alter table test1 modify column field_name int comment 'modified field comments';-- Note: just write the field name and field type.

The method of viewing table comments

-- look at show create table test1;-- in the generated SQL statement and look at use information_schema;select * from TABLES where TABLE_SCHEMA='my_db' and TABLE_NAME='test1'\ G in the metadata table.

How to view field comments

-- showshow full columns from test1;-- has read select * from COLUMNS where TABLE_SCHEMA='my_db' and TABLE_NAME='test1'\ G in the metadata table after reading this article. I believe you have some understanding of mysql's method of viewing field comments. You want to know more about it. Welcome to follow the industry information channel. Thank you for your reading!

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.