.jpg)
下面小編就為大家?guī)硪黄?a href="http://m.babyishan.com/?golink=aHR0cDovL3d3dy5waHAuY24vd2lraS8xMTYwLmh0bWw=" target="_blank" rel="noopener">mysql一個語句查出各種整形占用字節(jié)數(shù)及最大最小值的實例。
直接上碼：
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>33,-(1>41,-(1>49,-(1>57,-(1
? 版權(quán)聲明
文章版權(quán)歸作者所有，未經(jīng)允許請勿轉(zhuǎn)載。
THE END
.png)
