用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)
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)
如果字数少的话 也可以用 varchar