mysql数据类型-整型

• int[(m)][unsigned][zerofill]

  int		表示有符号，取值范围：-2147483648 ～ 2147483647
  int unsigned	表示无符号，取值范围：0 ～ 4294967295
  int(5)zerofill	仅用于显示，当不满足5位时，按照左边补0，例如：00002；满足时，正常显示。
  

  mysql> create table L1(id int, uid int unsigned, zid int(5) zerofill) default charset=utf8;
  Query OK, 0 rows affected (0.03 sec)
  
  mysql> insert into L1(id,uid,zid) values(1,2,3);
  Query OK, 1 row affected (0.00 sec)
  
  mysql> insert into L1(id,uid,zid) values(2147483641,4294967294,300000);
  Query OK, 1 row affected (0.00 sec)
  
  mysql> select * from L1;
  +------------+------------+--------+
  | id         | uid        | zid    |
  +------------+------------+--------+
  |          1 |          2 |  00003 |
  | 2147483641 | 4294967294 | 300000 |
  +------------+------------+--------+
  2 rows in set (0.00 sec)
  
  mysql> insert into L1(id,uid,zid) values(214748364100,4294967294,300000);
  ERROR 1264 (22003): Out of range value for column 'id' at row 1
  mysql>
  

• tinyint[(m)] [unsigned] [zerofill]

  有符号，取值范围：-128 ～ 127.
  无符号，取值范围：0 ～ 255
  

• bigint[(m)][unsigned][zerofill]

  有符号，取值范围：-9223372036854775808 ～ 9223372036854775807
  无符号，取值范围：0  ～  18446744073709551615