摘要:
下文讲述mysql数据表设计时int(n) tinyint(n)的用途说明,如下所示:
在mysql数据库中,
tinyint在mysql数据库中占用1个字节
int占用4个字节
int(1),int(2),int(3)...这些可存储的内容无差异,都可以存储4个字节的数据
tinyint(1),tinyint(2),tinyint(3)...同理,都可以存储1个字节的数据
--------------------------------------------------
int(n) tinyint(n) 在mysql数据库中,主要其查询数据时,数据显示的作用
当数据的位数小于n时,前面采用0补充
当数据的位数大于n时,则全部显示
---------------------------------------------------
注意事项:
int(n)必须结合zerofill属性一起使用
例:
mysql> create table `maomao365.com`
-> (keyId int(2) UNSIGNED ZEROFILL);
Query OK, 0 rows affected (0.00 sec)
mysql> insert into `maomao365.com`(keyId)values(111);
Query OK, 1 row affected (0.00 sec)
mysql> insert into `maomao365.com`(keyId)values(11);
Query OK, 1 row affected (0.00 sec)
mysql> insert into `maomao365.com`(keyId)values(8);
Query OK, 1 row affected (0.00 sec)
mysql> insert into `maomao365.com`(keyId)values(88);
Query OK, 1 row affected (0.00 sec)
mysql> insert into `maomao365.com`(keyId)values(888);
Query OK, 1 row affected (0.00 sec)
mysql> insert into `maomao365.com`(keyId)values(8888);
Query OK, 1 row affected (0.00 sec)
mysql> select * from `maomao365.com`;
+-------+
| keyId |
+-------+
| 111 |
| 11 |
| 08 |
| 88 |
| 888 |
| 8888 |
+-------+
6 rows in set (0.00 sec)
mysql int后面跟数字的示例分享