如何解决“针对列调整的超出范围的值"错误? [英] How do I fix the 'Out of range value adjusted for column' error?

问题描述

我进入phpMyAdmin，并将integer(15)字段的值更改为10位数字，因此一切正常.我输入了值"4085628851"，并且收到以下错误:

I went into phpMyAdmin and changed the value for an integer(15)field to a 10-digit number, so everything should work fine. I entered the value '4085628851' and I am receiving the following error:

警告:#1264超出范围值 针对第1行的电话"列进行了调整

Warning: #1264 Out of range value adjusted for column 'phone' at row 1

然后将值更改为"2147483647".

It then changes the value to '2147483647'.

在进行一些谷歌搜索之后，我发现了这篇文章，其中介绍了如何解决此问题. http://webomania. wordpress.com/2006/10/01/out-of-range-value-adjusted-for-column-error/，但我不知道如何登录Mysql shell.

After some googling, I found this article that explains how to fix the problem. http://webomania.wordpress.com/2006/10/01/out-of-range-value-adjusted-for-column-error/, but I don't know how to login to the Mysql shell.

如何登录Mysql Shell?如何解决此错误?

How do I login to the Mysql shell? How do I fix this error?

推荐答案

对于带符号的INT字段，您尝试设置的值太大.显示宽度(15)不会影响可以存储的值的范围，只会影响值的显示方式.

The value you were trying to set is too large for a signed INT field. The display width (15) does not affect the range of values that can be stored, only how the value is displayed.

引用:有关数字的MySQL文档

关于电话号码-参见

这篇关于如何解决“针对列调整的超出范围的值"错误?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！