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

mysql types int
Gaurav picture Gaurav · Apr 12, 2011 · Viewed 444.6k times · Source

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

And Maximum value that can be stored in this columns?

Answer

Matt MacLean picture Matt MacLean · Apr 12, 2011

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)

Related questions

MySQL integer field is returned as string in PHP

I have a table field in a MySQL database: userid INT(11) So I am calling it to my page with this query: "SELECT userid FROM DB WHERE name='john'" Then for handling the result I do: $row=$result->fetch_…

Read More
MySQL datatype INT(11) whereas UNSIGNED INT(10)?

in MySQL if we create a field dataType of INT and does not specify any length/values then it automatically became int(11) and if we set the attribute UNSIGNED or UNSIGNED ZEROFILL then it turns into int(10) Where does this …

Read More
What data type to use for hashed password field and what length?

I'm not sure how password hashing works (will be implementing it later), but need to create database schema now. I'm thinking of limiting passwords to 4-20 characters, but as I understand after encrypting hash string will be of different length. …

Read More