Home

Category: Main »

Questions

· Q: 29: Curious value 2147483647 in MySQL.
When using the INT data type, the number range is -2147483648 to 2147483647. If you try to insert a higher number, MySQL clips the value to the higher endpoint of the range and stores 2147483647 instead. If you want to exceed this range, use the BIGINT data type.