How do I fix the ‘Out of range value adjusted for column’ error?

by

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.

Ref: MySQL Docs on numerics

On phone numbers – see Is it better to store telephone numbers in some canonical format or “as entered”?

More Related Contents:

  1. How to populate a table with a range of dates?
  2. Check overlap of date ranges in MySQL
  3. Checking a table for time overlap?
  4. group by range in mysql
  5. How to get a ranking result for special record in mysql [closed]
  6. How to create a MySQL hierarchical recursive query?
  7. MySQL ERROR 1045 (28000): Access denied for user ‘bill’@’localhost’ (using password: YES)
  8. How to reset AUTO_INCREMENT in MySQL
  9. MySQL Query GROUP BY day / month / year
  10. MySQL Server has gone away when importing large sql file
  11. What is MySQL row order for “SELECT * FROM table_name;”?
  12. MySQL Like multiple values
  13. Error: select command denied to user ”@” for table ”
  14. Problems with contenttypes when loading a fixture in Django
  15. How to convert time to the time zone of the iPhone device?
  16. MySQL: Sort GROUP_CONCAT values
  17. Entity Framework wizard crashes on MySQL
  18. Mysql to select month-wise record even if data not exist
  19. Facebook like notifications tracking (DB Design)
  20. MySQL – how many rows can I insert in one single INSERT statement?
  21. How do I show the schema of a table in a MySQL database?
  22. MySQL Stored Procedure Error Handling
  23. Mysql delete statement with limit
  24. How can I cast an int to a bit in MySQL 5.1?
  25. update a column by subtracting a value
  26. Workaround in mysql for partial Index or filtered Index?
  27. MySQL: Querying for unicode entities
  28. undefined method `eq’ for nil:NilClass with rails 3 and ruby enterprise on ubuntu hardy
  29. MySQL data directory location
  30. INSERT INTO fails with node-mysql

Leave a Comment