下面小编就为大家带来一篇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 'tinyint unsigned','1',~0>>56,0 union select 'signed bigint','8',~0>>1,-(1>33,-(1>41,-(1>49,-(1>57,-(1
© 版权声明
文章版权归作者所有,未经允许请勿转载。
THE END