用COMMENT代替
mysql> use test;
Database changed
mysql> desc bb;
+-------+------------------+------+-----+---------------------+----------------+| Field | Type             | Null | Key | Default             | Extra          |+-------+------------------+------+-----+---------------------+----------------+| id    | int(10) unsigned |      | PRI | NULL                | auto_increment || a     | varchar(45)      |      |     |                     |                || b     | varchar(45)      |      |     |                     |                || d     | datetime         |      |     | 0000-00-00 00:00:00 |                |+-------+------------------+------+-----+---------------------+----------------+4 rows in set (0.00 sec)mysql> alter  table bb modify column b varchar(20) COMMENT 'my explain';
Query OK, 3 rows affected (0.63 sec)
Records: 3  Duplicates: 0  Warnings: 0mysql> show full columns from bb;
+-------+------------------+-----------------+------+-----+---------------------
+----------------+---------------------------------+------------+
| Field | Type             | Collation       | Null | Key | Default
| Extra          | Privileges                      | Comment    |
+-------+------------------+-----------------+------+-----+---------------------
+----------------+---------------------------------+------------+
| id    | int(10) unsigned | NULL            |      | PRI | NULL
| auto_increment | select,insert,update,references |            |
| a     | varchar(45)      | utf8_general_ci |      |     |
|                | select,insert,update,references |            |
| b     | varchar(20)      | utf8_general_ci | YES  |     | NULL
|                | select,insert,update,references | my explain |
| d     | datetime         | NULL            |      |     | 0000-00-00 00:00:00
|                | select,insert,update,references |            |
+-------+------------------+-----------------+------+-----+---------------------
+----------------+---------------------------------+------------+
4 rows in set (0.00 sec)