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

This article mainly introduces how to update mysql notes, has a certain reference value, friends in need can refer to. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

Mysql can update comments by executing [ALTER TABLE `student` COMMENT `comment content`;] statement. After completion, you can check whether the comment has been updated successfully by executing the [SHOW CREATE TABLE `table_ name`;] statement.

First, create a student table with the following code:

CREATE TABLE `student` (

`id` int (11) AUTO_INCREMENT PRIMARY KEY COMMENT 'learn well', `name` varchar (32) NOT NULL DEFAULT''COMMENT' name', `sex`tinyint (1) NOT NULL COMMENT 'gender', `age`tinyint (4) NOT NULL COMMENT 'age', `class`varchar (32) NOT NULL DEFAULT''COMMENT' class') ENGINE=InnODB CHARSET=utf8 COMMENT=' student form'

Then execute the following statement to update the comment

ALTER TABLE `student`COMMENT 'Student form 2.0'

When you are finished, execute the following statement to view the table comments

SHOW CREATE TABLE `student` Thank you for reading this article carefully. I hope it will be helpful for everyone to share how to update the comments on mysql. At the same time, I also hope that you will support us, pay attention to the industry information channel, and find out if you encounter problems. Detailed solutions are waiting for you to learn!

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.