Mysql必读MySQL一个语句查出各种整形占用字节数及最大最小值的实

《Mysql必读MySQL一个语句查出各种整形占用字节数及最大最小值的实例》要点：
本文介绍了Mysql必读MySQL一个语句查出各种整形占用字节数及最大最小值的实例，希望对您有用。如果有疑问，可以联系我们。

MYSQL教程直接上码：

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',~0>>33,-(1<<31) union
select 'signed mediumint',~0>>41,-(1<<23) union
select 'signed smallint',~0>>49,-(1<<15) union
select 'signed tinyint',~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教程以上这篇MySQL一个语句查出各种整形占用字节数及最大最小值的实例便是小编分享给大家的全部内容了,希望能给大家一个参考,也希望大家多多支持编程之家PHP.

欢迎参与《Mysql必读MySQL一个语句查出各种整形占用字节数及最大最小值的实例》讨论，分享您的想法，编程之家 52php.cn为您提供专业教程。

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!