MySQL Error 1264 out of range value for column

Question

As I SET cust fax in a table in MySQL like this   cust fax integer 10  NOT NULL    and then I insert value like this   INSERT INTO database values   3172978990      but then it say       error 1264  out of value for column   And I want to know where the error is  My set  Or other   Any answer will be appreciated

User · Accepted Answer

The value 3172978990 is greater than 2147483647 – the maximum value for INT – hence the error. MySQL integer types and their ranges are listed here.

Also note that the (10) in INT(10) does not define the "size" of an integer. It specifies the display width of the column. This information is advisory only.

To fix the error, change your datatype to VARCHAR. Phone and Fax numbers should be stored as strings. See this discussion.

User · Answer

You can also change the data type to bigInt and it will solve your problem  it s not a good practice to keep integers as strings unless needed      ALTER TABLE T PERSON MODIFY mobile no BIGINT

User · Answer

tl dr  Make sure your AUTO INCREMENT is not out of range  In that case  set a new value for it with   ALTER TABLE table name AUTO INCREMENT 100 -- Change 100 to the desired number   Explanation  AUTO INCREMENT can contain a number that is bigger than the maximum value allowed by the datatype  This can happen if you filled up a table that you emptied afterward but the AUTO INCREMENT stayed the same  but there might be different reasons as well  In this case a new entry s id would be out of range   Solution  If this is the cause of your problem  you can fix it by setting AUTO INCREMENT to one bigger than the latest row s id  So if your latest row s id is 100 then   ALTER TABLE table name AUTO INCREMENT 101   If you would like to check AUTO INCREMENT s current value  use this command    SELECT  AUTO INCREMENT  FROM  INFORMATION SCHEMA TABLES WHERE TABLE SCHEMA    DatabaseName  AND   TABLE NAME      TableName

User · Answer

You are exceeding the length of int datatype  You can use UNSIGNED attribute to support that value    SIGNED INT can support till 2147483647 and with UNSIGNED INT allows double than this  After this you still want to save data than use CHAR or VARCHAR with length 10

User · Answer

Work with   ALTER TABLE  table  CHANGE  cust fax   cust fax  VARCHAR 60  NULL DEFAULT NULL

[mysql] MySQL Error 1264: out of range value for column

Examples related to mysql

Examples related to sql

Examples related to insert

Examples related to integer