blocks|key|361580|text|Int有最大值范围：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|361581|INT+4+++-2147483648+2147483647
++++++++0+++4294967295+(unsigned+)|code-block|syntax|javascript|361582|因此，由于溢出，您将获得最大值。改用bigint，它有8个字节，这样就可以了。|361583|http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html#integer-types|offset|length|361584|BIGINT++8+++-9223372036854775808++++9223372036854775807
++++++++++0+++++++++++++++++18446744073709551615|361585|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|0|1Z|0|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|W|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|X|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|Y|8|@]|9|@$K|Z|L|10|1|11]]|A|$]]|$1|M|3|N|5|D|7|12|8|@]|9|@]|A|$E|F]]|$1|O|3|-4|5|6|7|13|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|J]]]]

Int has maximum value range :

<pre><code>INT 4 -2147483648 2147483647
 0 4294967295 (unsigned )
</code></pre>

hence, you are getting the maximum value due to the overflow.
use bigint instead, which has 8 bytes
and you shall be fine.

<a href="http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html#integer-types" rel="nofollow">http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html#integer-types</a>

<pre><code>BIGINT 8 -9223372036854775808 9223372036854775807
 0 18446744073709551615
</code></pre>

blocks|key|4546098|text|MySQL的整型字段中可能的最大值是2147483647，您的值9100000010大于该值。这就是为什么它会溢出到4294967295，这是无符号整数的最大值。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4546099|11.1.4.1.+Integer+Types+(Exact+Value)|4546100|INT++++4++++-2147483648+2147483647|code-block|syntax|javascript|4546101|如果要存储更大的数字，请使用BIGINT，范围为：|4546102|BIGINT++8+++-9223372036854775808++++9223372036854775807|4546103|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html^0|I|A|W|A|1M|A|0|0|11|0|0|0|E|6|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@$9|Z|A|10|B|C]|$9|11|A|12|B|C]|$9|13|A|14|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|15|8|@]|D|@$9|16|A|17|1|18]]|E|$]]|$1|H|3|I|5|J|7|19|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|1A|8|@$9|1B|A|1C|B|C]]|D|@]|E|$]]|$1|O|3|P|5|J|7|1D|8|@]|D|@]|E|$K|L]]|$1|Q|3|-4|5|6|7|1E|8|@]|D|@]|E|$]]]|R|$S|$5|T|U|V|E|$W|X]]]]

Largest value possible in INT field in MySQL is <code>2147483647</code>, your value <code>9100000010</code> is greater than that. That is why it is overflowing to <code>4294967295</code> which is Max for Unsigned Integer. 

<a href="http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html" rel="noreferrer">11.1.4.1. Integer Types (Exact Value)</a>

<pre><code>INT 4 -2147483648 2147483647
</code></pre>

Use <code>BIGINT</code> if you want to store larger number, which ranges from:

<pre><code>BIGINT 8 -9223372036854775808 9223372036854775807
</code></pre>

blocks|key|1196665|text|在MySQL中，INT(10)并不意味着值仅限于10个字符值。这只意味着MySQL在返回这些值时会尝试用空格/零来填充它们。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1196666|任何带符号的INT，包括INT(+10+)、INT(5)或任何其他INT(n)的数值范围是：-2,147,483,648+...+2,147,483,647，最多10位。|1196667|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

In MySQL, INT(10) does not mean that values are limited to 10-character values. It only means that MySQL will try to pad these values with spaces/zeroes when returning them. 

The numeric range of any signed INT including INT(10), INT(5) or any other INT(n) is:
 -2,147,483,648 ... 2,147,483,647, which is 10 digits at most.

blocks|key|1196529|text|我相信你得到的是int+max值。INT(10)用于数字填充，而不是限制字符数。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1196530|当返回这些值时，MySQL会尝试用空格/零来填充它们。|1196531|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

I belive you get int max value. INT(10) is ment for number padding not for limiting number of characters.

MySQL will try to pad these values with spaces/zeroes when returning them.

blocks|key|361634|text|您已达到int的最大值。mysql中int的最大取值范围为4294967295+(无符号)。所以你必须使用BIGINT。你可以在这里获得更多信息：Mysql+Numeric+types|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|361635|希望这能有所帮助|361636|亲切的问候|361637|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.1/en/numeric-types.html#integer-types^0|21|J|0|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]]|C|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@]|C|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|O]]]]

you reached the maximum for int. 
The int maximum value range for int in mysql is 4294967295 (unsigned). 
So you have to use BIGINT. You can get more informations about this here: 
<a href="http://dev.mysql.com/doc/refman/5.1/en/numeric-types.html#integer-types" rel="nofollow">Mysql Numeric types</a>

Hope this helps 

Kind Regards

blocks|key|361642|text|type|unstyled|depth|inlineStyleRanges|entityRanges|data|361643|，它应该允许10位数字，对吧？|blockquote|361644|361645|361646|NO，mySQL中整型和整型的大小是在指定了的情况下设置字段显示宽度。|offset|length|style|BOLD|361647|例如，如果您插入的值是123456，那么当您查询它时，它将显示为0000123456，它只是显示宽度，不会影响该值。|361648|因此，值范围由数据类型本身决定，而不是由显示宽度决定。要存储更大的值，应该将数据类型更改为合适的类型，如BIGINT。|361649|来自mySQL+reference|361650|INT+:+A+normal-size+integer.+The+signed+range+is+-2147483648+to+2147483647.+The+unsigned+range+is+0+to+4294967295.|CODE|361651|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html#integer-types|1|http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html^0|0|0|0|0|0|2|J|3|0|0|1G|6|0|0|2|F|1|0|0|36|0^^$0|@$1|2|3|-4|4|5|6|14|7|@]|8|@]|9|$]]|$1|A|3|B|4|C|6|15|7|@]|8|@]|9|$]]|$1|D|3|-4|4|5|6|16|7|@]|8|@]|9|$]]|$1|E|3|-4|4|5|6|17|7|@]|8|@]|9|$]]|$1|F|3|G|4|5|6|18|7|@$H|19|I|1A|J|K]|$H|1B|I|1C|J|K]]|8|@]|9|$]]|$1|L|3|M|4|5|6|1D|7|@]|8|@]|9|$]]|$1|N|3|O|4|5|6|1E|7|@]|8|@$H|1F|I|1G|1|1H]]|9|$]]|$1|P|3|Q|4|5|6|1I|7|@]|8|@$H|1J|I|1K|1|1L]]|9|$]]|$1|R|3|S|4|5|6|1M|7|@$H|1N|I|1O|J|T]]|8|@]|9|$]]|$1|U|3|-4|4|5|6|1P|7|@]|8|@]|9|$]]]|V|$W|$4|X|Y|Z|9|$10|11]]|12|$4|X|Y|Z|9|$10|13]]]]

<blockquote>
 It should have allowed 10 digits there, right?
</blockquote>

NO, size of INT and integer types in mySQL is to set the display width when field has ZEROFILL specified.

for example if the value you inserted is 123456 then when you query it, it will displays as 0000123456 , it is just the display width and doesn't affect the value. 

so the value range is determined by the datatype itself, not the display width. to store greater values, you should change the datatype to a suitable one, like <a href="http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html#integer-types" rel="nofollow">BIGINT</a>.

from <a href="http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html" rel="nofollow">mySQL reference</a>:

<code>INT : A normal-size integer. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295.</code>

I have this column that's
<code>INT(10) ZEROFILL NOT NULL DEFAULT '0000000000',</code>

But when I insert something like <code>9100000010</code>, I get <code>4294967295</code>

It should have allowed 10 digits there, right?

How to do this right?

Why can't I insert 10 digits when my column is INT(10)

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我有一个名为INT(10) ZEROFILL NOT NULL DEFAULT '0000000000',的专栏但是当我插入像9100000010这样的东西时，我得到的是4294967295它应该允许那里有10个数字，对吗？如何正确地做到这一点？

问当我的列是INT( 10 )时，为什么不能插入10位数字
EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问当我的列是INT( 10 )时，为什么不能插入10位数字EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问当我的列是INT( 10 )时，为什么不能插入10位数字
EN