下面小编就为大家带来一篇MySQL一个语句查出各种整形占用字节数及最大最小值的实例。

直接上码： 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 'ti