MySQL一个语句查出各种整形占用字节数及最大最小值
2024-09-16 22:46:11
直接上码:
select 'bigint unsigned' as type ,'' as bytes ,~0 as max_num,0 as min_num union
select 'int unsigned','',~0>>32,0 union
select 'mediumint unsigned','',~0>>40,0 union
select 'smallint unsigned','',~0>>48,0 union
select 'tinyint unsigned','',~0>>56,0 union
select 'signed bigint','',~0>>1,-(1<<63) union
select 'signed int','',~0>>33,-(1<<31) union
select 'signed mediumint','',~0>>41,-(1<<23) union
select 'signed smallint','',~0>>49,-(1<<15) union
select 'signed tinyint','',~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 |
+--------------------+-------+----------------------+----------------------+
10 rows in set (0.00 sec)
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
最新文章
- 介绍一个非常好用的跨平台C++开源框架:openFrameworks
- 作业三 代码规范 代码复审 PSP
- Java操作Oracle
- Android开发中Handler的经典总结
- java并发:获取线程执行结果(Callable、Future、FutureTask)
- C#: 方法的默认参数
- 事后调试之MiniDump转储
- Python zxing 库解析(条形码二维码识别)
- ZOJ 3607贪心算法
- 给Ubuntu安装KDE桌面 [转]
- 【转载】CANoe 入门 Step by step系列(三)简单例子的剖析
- VSCode Python开发环境配置
- Python 函数的作用域
- Linux 实验一 基础实践
- JSTL介绍及使用
- git pull 错误:The following untracked working tree files would be overwritten by merge
- CSS一个属性,让图片后的文字垂直居中,效果看得见
- Mysql报Packet for query is too large (1040 >; 1024)错误
- 【原】Coursera—Andrew Ng机器学习—课程笔记 Lecture 11—Machine Learning System Design 机器学习系统设计
- mybatis3 sqlsession
热门文章
- 用DataGridView导入TXT文件,并导出为XLS文件
- MVC学习一:EF
- Windows建立Cucumber和Ruby测试环境
- SQL Server 深入解析索引存储(中)
- 《R in Action》读书笔记(1)
- [SQLServer大对象]——FileTable从文件系统迁移文件
- C语言 &#183; 未名湖边的烦恼
- Mysql 备份
- 2013 duilib入门简明教程 -- XML配置界面(6)
- 解决OracleConnection ORA-1017 和 HRESULT:0x8007000B 错误