mysql显示宽度_mysql5.5 表列显示宽度的修改_binary(x)

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                              |<