MySQL tinyint/smallint/int/bigint

最新推荐文章于 2024-09-18 21:57:25 发布

神MiRen

最新推荐文章于 2024-09-18 21:57:25 发布

阅读量796

点赞数

CC 4.0 BY-SA版权

分类专栏： GavinLau - MySQL 文章标签： mysql int tinyint smallint bigint

本文链接：https://blog.youkuaiyun.com/iamlauy/article/details/78553061

GavinLau - MySQL 专栏收录该内容

2 篇文章

订阅专栏

本文详细介绍了MySQL中不同整型数据类型的存储大小及取值范围，包括tinyint、smallint、int和bigint等，帮助读者更好地理解并选择合适的类型。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

MySQL tinyint/smallint/int/bigint取值范围

数据类型	存储大小	取值范围	最大存储位数
tinyint	1 字节	signed : -128 ~ 127	3位
		unsigned : 0 ~ 255	3位

smallint	2 字节	signed : -32768 ~ 32767	5位
		unsigned : 0 ~ 65535	5位

int	4 字节	signed : -2147483648 ~ 2147483647	10位
		unsigned : 0 ~ 4294967295	10位

bigint	8 字节	signed : -9223372036854775808 ~ 9223372036854775807	19位
		unsigned : 0 ~ 18446744073709551615	20位

    mysql> help tinyint;

    A very small integer. 
    The signed range is -128 to 127. 
    The unsigned range is 0 to 255.

    mysql> help smallint;

    A small integer. 
    The signed range is -32768 to 32767. 
    The unsigned range is 0 to 65535.

    mysql> help int;

    A normal-size integer. 
    The signed range is -2147483648 to 2147483647.
    The unsigned range is 0 to 4294967295.

    mysql> help bigint;

    A large integer. 
    The signed range is -9223372036854775808 to 9223372036854775807. 
    The unsigned range is 0 to 18446744073709551615.