What is the MAX number if I store int(255) in MySQL?

by

Something is probably just converting that to int(11) for you. Since you can’t have 255 visible digits in an int, the maximum value will be 2147483647.

If you need more than that you can set it to be unsigned, since I’m assuming you have no negative ids and then you can have up to 4294967295.

If you are ever going to have more than 4 billion records (very unlikely if you’re at 1 million right now), then you could use a bigint instead, which allows you to store numbers up to 18446744073709551615 at a cost of more storage space of course.

More Related Contents:

  1. What is the size of column of int(11) in mysql in bytes?
  2. MySQL INT meaning
  3. What to do when you need integers larger than 20 digits on mysql?
  4. 1052: Column ‘id’ in field list is ambiguous
  5. Codeigniter – multiple database connections
  6. How to add levenshtein function in mysql?
  7. How to search JSON data in MySQL?
  8. MySQL > Table doesn’t exist. But it does (or it should)
  9. #1071 – Specified key was too long; max key length is 1000 bytes
  10. Is the primary key automatically indexed in MySQL?
  11. Is there ANY_VALUE capability for mysql 5.6?
  12. Cumulative sum over a set of rows in mysql
  13. MySql Error 150 – Foreign keys
  14. Set NOW() as Default Value for datetime datatype?
  15. No connection could be made because the target machine actively refused it (PHP / WAMP)
  16. Add Auto-Increment ID to existing table?
  17. MySQL SELECT DISTINCT multiple columns
  18. SQL DELETE with JOIN another table for WHERE condition
  19. How to connect to a MySQL Data Source in Visual Studio
  20. DOs and DONTs for Indexes [closed]
  21. MySQL: #1075 – Incorrect table definition; autoincrement vs another key?
  22. How to insert images from database?
  23. MySQL – ORDER BY values within IN()
  24. MySQL convert timediff output to day, hour, minute, second format
  25. How do I rename a MySQL database (change schema name)?
  26. MySQL my.cnf file – Found option without preceding group
  27. Returning records from the last 3 months only in MySQL
  28. How to initialize mysql container when created on Kubernetes?
  29. Find duplicates in the same table in MySQL
  30. Auto-increment is not resetting in MySQL

Leave a Comment