Shulou(Shulou.com)05/31 Report--

This article mainly shows you "how to modify comments in the mysql database", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "how to modify notes in the mysql database" this article.

Method: 1, use "alter table table name comment 'modified comment';" statement modify table comment; 2, use "alter table table name modify field name column comment type 'modified comment';" statement modify field comment.

The operating environment of this tutorial: windows10 system, mysql8.0.22 version, Dell G3 computer.

1 write comments when creating the table and use the comment keyword

Syntax:

Create table table name (field name type comment 'comments for fields') comments for comment=' table'

Check it out

2 modify the comments of the table

Alter table table name comment 'comments for modified table'

3 modify the comments of the field

Alter table table name modify field name column comment type 'modified field comment'

4 the method of viewing the comments of the table

-- in the generated SQL statement

Show create table table name

-- look inside the metadata table

Use information_schema;select * from TABLES where TABLE_SCHEMA=' database name 'and TABLE_NAME=' table name'

5 ways to view field comments

-- show

Show full columns from table name

-- look inside the metadata table

Select * from COLUMNS where TABLE_SCHEMA=' database name 'and TABLE_NAME=' table name'\; the above is all the contents of the article "how to modify comments in mysql Database". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.