直接上码：

select 'bigint unsigned' as type ,'8' as bytes ,~0 as max_num,0 as min_num unionselect 'int unsigned','4',~0>>32,0 unionselect 'mediumint unsigned','3',~0>>40,0 unionselect 'smallint unsigned','2',~0>>48,0 unionselect 'tinyint unsigned','1',~0>>56,0 unionselect 'signed bigint','8',~0>>1,-(1<<63) unionselect 'signed int','4',~0>>33,-(1<<31) unionselect 'signed mediumint','3',~0>>41,-(1<<23) unionselect 'signed smallint','2',~0>>49,-(1<<15) unionselect '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)

更多相关文章

1. Android(安卓)-- Android(安卓)JUint 与 Sqlite
2. 链接器解析多重定义的全局变量
3. android 当系统存在多个Launcher时，如何设置开机自动进入默认的La
4. Android(安卓)SQLiteDatabase的使用
5. android sqlite 图片保存和读出
6. 监听TextView的变动
7. android 通话记录次数
8. Android(安卓)SQLiteDatabase的使用
9. Android(安卓)DEX安全攻防战

随机推荐

1. Aptana Studio 3 IDE中有运行JavaScript
2. 使用异步库汇编数据库中的所有标记
3. 在angularjs中动态添加/删除checked属性
4. HTML最简单的隐藏/显示和类过滤器
5. javascript阻塞加载问题【转】
6. AngularJS：登录cookie过期时如何注销
7. 调用另一个html页面后，选择列表值不会保持
8. 怎么javascript读取本地文件中的数据，并显
9. RequireJS中的命名模块与未命名模块
10. 更新:在Gulpfile中带有postCSS和Babel的