Difference between revisions of "Error Code: 1062. Duplicate entry '2147483647' for key"
Jump to navigation
Jump to search
(Created page with "<hide> page type::article thing type::error message returned by::MySQL category:error messages </hide> ==About== "Error Code: 1062. Duplicate entry '21474836...") |
(No difference)
|
Latest revision as of 20:05, 29 August 2015
About
"Error Code: 1062. Duplicate entry '2147483647' for key <key name>" is an error message returned by MySQL when a query attempts to set a signed 4-byte integer field to an unsigned value that is too large to represent as a signed 4-byte integer. "2147483647" is 7F.FF.FF.FF in hexadecimal, i.e. the largest positive 4-byte signed integer.
You will get this error if you try to store 2147483648 (or any larger integer) in a 4-byte signed integer (INT(11) SIGNED) field.