更改 int 字段为 unsigned 后默认宽度就从 11 变成 10 是什么原因

[LYEHIZRF]

如下

mysql> desc a1;
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| id    | int(11)     | YES  |     | NULL    |       |
| name  | varchar(20) | YES  |     | NULL    |       |
+-------+-------------+------+-----+---------+-------+
2 rows in set (0.23 sec)

mysql> alter table a1 modify id int zerofill;
Query OK, 0 rows affected (0.55 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> desc a1;
+-------+---------------------------+------+-----+---------+-------+
| Field | Type                      | Null | Key | Default | Extra |
+-------+---------------------------+------+-----+---------+-------+
| id    | int(10) unsigned zerofill | YES  |     | NULL    |       |
| name  | varchar(20)               | YES  |     | NULL    |       |
+-------+---------------------------+------+-----+---------+-------+
2 rows in set (0.03 sec)

mysql> alter table a1 modify id int(11) zerofill;
Query OK, 0 rows affected (0.36 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> desc a1;
+-------+---------------------------+------+-----+---------+-------+
| Field | Type                      | Null | Key | Default | Extra |
+-------+---------------------------+------+-----+---------+-------+
| id    | int(11) unsigned zerofill | YES  |     | NULL    |       |
| name  | varchar(20)               | YES  |     | NULL    |       |
+-------+---------------------------+------+-----+---------+-------+
2 rows in set (0.03 sec)
    
mysql> alter table a1 modify id int unsigned;
Query OK, 0 rows affected (0.31 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> desc a1;
+-------+------------------+------+-----+---------+-------+
| Field | Type             | Null | Key | Default | Extra |
+-------+------------------+------+-----+---------+-------+
| id    | int(10) unsigned | YES  |     | NULL    |       |
| name  | varchar(20)      | YES  |     | NULL    |       |
+-------+------------------+------+-----+---------+-------+
2 rows in set (0.06 sec)

[misaka19000]

为什么我在外面看标题是 zerofill，到里面就变成 unsigned 了？

[est]

因为不用显示 负号 了啊。。

那个 10 11 表示显示宽度。

4294967296 10 个字符
-2147483648 11 个字符。

[MajorAdam]

符号位

[LYEHIZRF]

@est @MajorAdam soga 感谢 以前真没注意这个
@misaka19000 哈哈因为马上 edit 了

[lanjz]

MySQL 那个宽度对数值类型似乎不起作用？ int(1) 和 int(10) 能存储的一样啊

[iyangyuan]

如果不在数据库里做格式化，这个没什么用吧