MySQL使用一个语句就可以查出各种整形占用字节数及最大最小值的示例代码

直接上码：

select 'bigint unsigned' as type ,'8' as bytes ,~0 as max_num,0 as min_num union
select 'int unsigned','4',~0>>32,0 union
select 'mediumint unsigned','3',~0>>40,0 union
select 'smallint unsigned','2',~0>>48,0 union
select 'tinyint unsigned','1',~0>>56,0 union
select 'signed bigint','8',~0>>1,-(1<<63) union
select 'signed int','4',~0>>33,-(1<<31) union
select 'signed mediumint','3',~0>>41,-(1<<23) union
select 'signed smallint','2',~0>>49,-(1<<15) union
select 'signed tinyint','1',~0>>57,-(1<<7);

+--------------------+-------+----------------------+----------------------+
  type      bytes   max_num      min_num     
+--------------------+-------+----------------------+----------------------+
  bigint unsigned   8    18446744073709551615       0  
  int unsigned    4      4294967295       0  
  mediumint unsigned   3       16777215       0  
  smallint unsigned   2       65535       0  
  tinyint unsigned   1        255       0  
  signed bigint    8    9223372036854775807   -9223372036854775808  
  signed int     4      2147483647     -2147483648  
  signed mediumint   3       8388607      -8388608  
  signed smallint   2       32767      -32768  
  signed tinyint    1        127       -128  
+--------------------+-------+----------------------+----------------------+
rows in set (0.00 sec)

以上就是MySQL使用一个语句就可以查出各种整形占用字节数及最大最小值的示例代码的详细内容，更多请关注php中文网其它相关文章！