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一个语句查出各种整形占用字节数及最大最小值的实例就是小编分享给大家的全部内容了，希望能给大家一个参考，也希望大家多多支持毛票票。
热门推荐
6 保研的祝福语简短
10 年轻20岁祝福语简短
11 朋友结婚祝福语信息简短
12 女孩婚礼贺卡祝福语简短
13 30段点歌简短祝福语
14 虎年春节祝福语图文简短
15 写给后妈祝福语大全简短
16 简短回复生日祝福语
17 校长送毕业祝福语简短
18 毕业立体贺卡祝福语简短