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一个语句查出各种整形占用字节数及最大最小值的实例就是小编分享给大家的全部内容了,希望能给大家一个参考,也希望大家多多支持毛票票。