View source for Error Code: 1062. Duplicate entry '2147483647' for key

<hide>
[[page type::article]]
[[thing type::error message]]
[[returned by::MySQL]]
[[category:error messages]]
</hide>
==About==
"[[Error Code: 1062. Duplicate entry '2147483647' for key]] {{arg|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.