MySQL一個語句查出各種整形占用字節(jié)數(shù)及最大最小值的實(shí)例
更新時間:2017年03月21日 08:44:32 投稿:jingxian
下面小編就為大家?guī)硪黄狹ySQL一個語句查出各種整形占用字節(jié)數(shù)及最大最小值的實(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<<63) union select 'signed int','4',~0>>33,-(1<<31) union select 'signed mediumint','3',~0>>41,-(1<<23) union select 'signed smallint','2',~0>>49,-(1<<15) union select 'signed tinyint','1',~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一個語句查出各種整形占用字節(jié)數(shù)及最大最小值的實(shí)例就是小編分享給大家的全部內(nèi)容了,希望能給大家一個參考,也希望大家多多支持腳本之家。
相關(guān)文章
MySQL通過觸發(fā)器解決數(shù)據(jù)庫中表的行數(shù)限制詳解及實(shí)例
這篇文章主要介紹了MySQL通過觸發(fā)器解決數(shù)據(jù)庫中表的行數(shù)限制詳解及實(shí)例的相關(guān)資料,需要的朋友可以參考下2017-04-04MySQL存儲過程in、out和inout參數(shù)示例和總結(jié)
這篇文章主要給大家介紹了關(guān)于MySQL存儲過程in、out和inout參數(shù)的相關(guān)資料,文中通過示例代碼介紹的非常詳細(xì),對大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值,需要的朋友們下面隨著小編來一起學(xué)習(xí)學(xué)習(xí)吧2021-01-01如何通過配置自動實(shí)現(xiàn)ValueList中hql語句的整型參數(shù)轉(zhuǎn)換
本篇文章是對通過配置自動實(shí)現(xiàn)ValueList中hql語句的整型參數(shù)轉(zhuǎn)換進(jìn)行了詳細(xì)的分析介紹,需要的朋友參考下2013-06-06