Community
Learn
Tools Library
AI Tools
Leisure
search
English
Home > Database > Mysql Tutorial > MySQL整型：TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT的范围_MySQL

MySQL整型：TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT的范围_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release： 2016-06-01 13:30:17
Original
1792 people have browsed it

bitsCN.com

MySQL整型：TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT的范围

 

TINYINT：有符号的范围是-128至127，无符号的范围是0到255，2的8 次方

 

SMALLINT：有符号的范围是-32768至32767，无符号的范围是0到65535，2的16次方

 

MEDIUMINT：有符号的范围是-8388608至8388607，无符号的范围是0到16777215，2的24次方

 

INT(integer)：有符号的范围是-2147483648至2147483647，无符号的范围是0到4294967295，2的32次方

 

BIGINT：有符号的范围是-9223372036854775808至9223372036854775807，无符号的范围是0到18446744073709551615，2的64次方

 

bitsCN.com
Previous article：MySQL数据库中的REPAIRTABLE语法介绍_MySQL Next article：Mysql存储过程查询结果赋值到变量的方法_MySQL
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
3
2806
How to display the mobile version of Google Chrome Hello teacher, how can I change Google Chrome into a mobile version?
From 2024-04-23 00:22:19
0
11
2936
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
2449
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
2371
Where is the courseware about CSS mind mapping? Courseware
From 2024-04-16 10:10:18
0
0
2433
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template