Implementation of adding remark information to mysql

Preface

Some people have asked me some MySQL notes these days, so I have to write a blog post.

1. When creating a table, add table name notes and field notes

CREATE TABLE `healerjean_comment` (
 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `name` varchar(32) NOT NULL COMMENT 'Name Comment',
 `email` varchar(64) NOT NULL,
 `message` text,
 PRIMARY KEY (`id`),
 KEY `index_name` (`name`)
) COMMENT = 'Table name comments';

2. After the table is created, add table name notes and field notes

ALTER TABLE healerjean_comment COMMENT='Test index table';
ALTER table healerjean_comment MODIFY name VARCHAR(32) NOT NULL COMMENT 'Name comment'

3. View notes

show create table healerjean; 

show full columns from healerjean; 

This is the end of this article about how to add remark information to MySQL. For more information about how to add remark information to MySQL, please search for previous articles on 123WORDPRESS.COM or continue to browse the following related articles. I hope you will support 123WORDPRESS.COM in the future!