MySQL一个语句查出各种整形占用字节数及最大最小值的实例
直接上码:
select'bigintunsigned'astype,'8'asbytes,~0asmax_num,0asmin_numunion select'intunsigned','4',~0>>32,0union select'mediumintunsigned','3',~0>>40,0union select'smallintunsigned','2',~0>>48,0union select'tinyintunsigned','1',~0>>56,0union select'signedbigint','8',~0>>1,-(1<<63)union select'signedint','4',~0>>33,-(1<<31)union select'signedmediumint','3',~0>>41,-(1<<23)union select'signedsmallint','2',~0>>49,-(1<<15)union select'signedtinyint','1',~0>>57,-(1<<7); +--------------------+-------+----------------------+----------------------+ |type|bytes|max_num|min_num| +--------------------+-------+----------------------+----------------------+ |bigintunsigned|8|18446744073709551615|0| |intunsigned|4|4294967295|0| |mediumintunsigned|3|16777215|0| |smallintunsigned|2|65535|0| |tinyintunsigned|1|255|0| |signedbigint|8|9223372036854775807|-9223372036854775808| |signedint|4|2147483647|-2147483648| |signedmediumint|3|8388607|-8388608| |signedsmallint|2|32767|-32768| |signedtinyint|1|127|-128| +--------------------+-------+----------------------+----------------------+ rowsinset(0.00sec)
以上这篇MySQL一个语句查出各种整形占用字节数及最大最小值的实例就是小编分享给大家的全部内容了,希望能给大家一个参考,也希望大家多多支持毛票票。
热门推荐
1 训练狗狗憋尿
2 狗狗追踪训练
3 狗狗训练要多少钱
5 深圳狗狗训练
6 训练狗狗唤回
7 狗狗叫怎么训练
8 狗狗训练班
10 狗狗社会化训练
11 狗狗叫回训练
12 广州狗狗训练学校
13 狗狗训练躺下
14 狗狗随行训练
15 训练狗狗巡回
16 狗狗要怎么训练
17 狗狗喂食训练
18 训练狗狗躺下