mysql> desc t1;
+-------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+------------+------+-----+---------+-------+
| a | bit(1) | YES | | NULL | |
| b | tinyint(4) | YES | | NULL | |
| c | binary(1) | YES | | NULL | | #binary默认显示宽度为1
+-------+------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
mysql> alter table t1 modify c binary(30);#修改显示宽度为30
Query OK, 5 rows affected (0.04 sec)
Records: 5 Duplicates: 0 Warnings: 0
mysql> select * from t1;#查询发现修改binary显示宽度前的列还是仅显示第一个字母,也就是显示宽度为1
+------+------+--------------------------------+
| a | b | c |<