What is the size of column of int(11) in mysql in bytes?

by

An INT will always be 4 bytes no matter what length is specified.

  • TINYINT = 1 byte (8 bit)
  • SMALLINT = 2 bytes (16 bit)
  • MEDIUMINT = 3 bytes (24 bit)
  • INT = 4 bytes (32 bit)
  • BIGINT = 8 bytes (64 bit).

The length just specifies how many characters to pad when selecting data with the mysql command line client. 12345 stored as int(3) will still show as 12345, but if it was stored as int(10) it would still display as 12345, but you would have the option to pad the first five digits. For example, if you added ZEROFILL it would display as 0000012345.

… and the maximum value will be 2147483647 (Signed) or 4294967295 (Unsigned)

More Related Contents:

  1. What column type/length should I use for storing a Bcrypt hashed password in a Database?
  2. MySQL integer field is returned as string in PHP
  3. Types in MySQL: BigInt(20) vs Int(20)
  4. What data type to use for hashed password field and what length?
  5. What is the benefit of zerofill in MySQL?
  6. What MySQL data type should be used for Latitude/Longitude with 8 decimal places?
  7. mysql equivalent data types
  8. MySQL INT meaning
  9. What to do when you need integers larger than 20 digits on mysql?
  10. What is the MAX number if I store int(255) in MySQL?
  11. Which DB technology is sued to solve the following search issue? [closed]
  12. mysql error cant fix the error [duplicate]
  13. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  14. How to escape apostrophe (‘) in MySql?
  15. How to join two tables mysql?
  16. SQL table with “list” entry vs SQL table with a row for each entry
  17. How do I restore a dump file from mysqldump?
  18. How to handle fragmentation of auto_increment ID column in MySQL
  19. MySQL – Conditional Foreign Key Constraints
  20. How to count items in comma separated list MySQL
  21. What effects does using a binary collation have?
  22. MySQL order by “best match”
  23. Are dynamic mysql queries with sql escaping just as secure as prepared statements?
  24. What’s the best database structure to keep multilingual data? [duplicate]
  25. Using an IF Statement in a MySQL SELECT query
  26. Insert/ Update random date in MySQL
  27. How to determine which database is selected
  28. Laravel MySql DB Connection with SSH
  29. Get column sum and use to calculate percent of total (mySQL)
  30. is there a length limit to group_concat or another reason why it would not work on a text field

Leave a Comment