What is the concept of mysql comment

comment means notes and comments. In the MySQL database, comments on fields or columns are added using the comment attribute; in scripts that create new tables, comments can be added by adding the comment attribute in the field definition script. To view comments for all fields in a table, you can execute the command "show full columns from table name".

In mysql, COMMENT means remarks and comments.

MySQL Add comment (comment)

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

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

The sample code is as follows:

create table test( 
	id int not null default 0 comment '用户id' 
)

If the table has been built, you can also use the command to modify the fields, and then add the comment attribute definition to add comments.

The sample code is as follows:

alter table test modify column id int not null default 0 comment '测试表id'

How about viewing the comments of all fields in an existing table?

You can use the command: show full columns from table to view, the example is as follows:

show full columns from test;

Write comments when creating the table

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

Modify table comments

alter table test1 comment '修改后的表的注释';

Modify field comments

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

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

How to view table comments

-- 在生成的SQL语句中看 
	show  create  table  test1; 
-- 在元数据的表里面看
	use information_schema; 
	select * from TABLES where TABLE_SCHEMA='my_db' and TABLE_NAME='test1' \G

How to view field comments

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

Four kinds of comments in mysql

NO1:- - Comment content

This comment method cannot implement multi-line comments. It should be noted that there is a space after the --. (-- The following content will not be recognized, so you need to add a semicolon on the next line to end the statement)

NO2: #Comment content

This comment method cannot implement multi-line comments.

NO3: /*Comment content */

This kind of comment can realize multi-line comments.

Insert picture description here

NO4：/*!Comment content*/

This kind of comment is called inline comment in mysql, when! When the database version number is connected later, when the actual version is equal to or higher than that string, the application will interpret the comment content as SQL, otherwise it will be treated as a comment. By default, when the version number is not connected, the content inside will be executed.

The above is the detailed content of What is the concept of mysql comment. For more information, please follow other related articles on the PHP Chinese website!