How to set field comments in mysql

Setting method: 1. Use the "create table table name (field name field type comment 'field comment');" statement; 2. Use "alter table table name modify column field name field type comment 'field The comment ';' statement.

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

In the MySQL database, comments on fields or columns are added using the comment attribute.

In the script that creates a new table, you can add comments by adding the comment attribute in the field definition script.

Write field comments when creating a table

create table test1 ( 
    field_name int comment '字段的注释' 
);

Modify field comments

alter table test1 modify column field_name int comment '修改后的字段注释'; 

-- 注意：字段名和字段类型照写就行

View field comments Method

-- show 
	show  full  columns  from  test1; 
-- 在元数据的表里面看 
	select * from COLUMNS where TABLE_SCHEMA='my_db' and TABLE_NAME='test1' \G

[Related recommendations: mysql video tutorial]

The above is the detailed content of How to set field comments in mysql. For more information, please follow other related articles on the PHP Chinese website!