Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

What does INT(5) in mysql mean?

Tags:

database

mysql

I always thought INT(5) means a number which has a max size of 5 digits. I tried entering a huge number inside it and it somehow got cut down to 2147483647

This obviously isnt 5 digits. So what does INT(5) have a limitation of ?

like image 262
YD8877 Avatar asked Jan 17 '12 09:01

YD8877

People also ask

What does Int 4 mean in MySQL?

For example, INT(4) specifies an INT with a display width of four digits. This optional display width may be used by applications to display integer values having a width less than the width specified for the column by left-padding them with spaces.

What does int mean in MySQL?

In MySQL, INTEGER (INT) is a numeric value without a decimal. It defines whole numbers that can be stored in a field or column. In addition, MySQL supports the display_width attribute (for example, INT(1)) and the ZEROFILL attribute, which automatically adds zeros to the value depending on the display width.

What does int 10 mean in SQL?

INT(10) means you probably defined it as INT UNSIGNED . So, you can store numbers from 0 up to 4294967295 (note that the maximum value has 10 digits, so MySQL automatically added the (10) in the column definition which (10) is just a format hint and nothing more. It has no effect on how big number you can store).

What means INT 11 in MySQL?

In MySQL integer int(11) has size is 4 bytes which equals 32 bit. Signed value is : - 2^(32-1) to 0 to 2^(32-1)-1 = -2147483648 to 0 to 2147483647. Unsigned values is : 0 to 2^32-1 = 0 to 4294967295.

2 Answers

From MySQL Docs, Numeric Type Attributes

MySQL supports an extension for optionally specifying the display width of integer data types in parentheses following the base keyword for the type. For example, INT(4) specifies an INT with a display width of four digits. This optional display width may be used by applications to display integer values having a width less than the width specified for the column by left-padding them with spaces. (That is, this width is present in the metadata returned with result sets. Whether it is used or not is up to the application.)

like image 97
ypercubeᵀᴹ Avatar answered Oct 15 '22 22:10

ypercubeᵀᴹ

INT is always four bytes wide. The 5 is the "display width".

like image 37
NPE Avatar answered Oct 15 '22 21:10

NPE
Sign in to Comment

Related questions

How to set max_connections in MySQL Programmatically
Changing Large MySQL InnoDB Tables
How to LOAD DATA INFILE in mysql with first col being Auto Increment?
Why is import of SQL so slow?
mysql Fatal error: cannot allocate memory for the buffer pool
Can you add an if statement in ORDER BY?
How to concatenate columns with Laravel 4 Eloquent?
Creating a procedure in mySql with parameters
How to check if a row exists in MySQL? (i.e. check if an email exists in MySQL)
Mysql - How to update a column using another column's value plus some strings
List of non-empty tables in MySQL database
Use multiple columns as unique identifier for mysql
How to backup MySQL database in PHP?
Order items in MySQL by a fixed list?
PDO fetchAll group key-value pairs into assoc array
How to join only one column?
How to update MySql timestamp column to current timestamp on PHP?
MYSQL_ROOT_PASSWORD is set but getting "Access denied for user 'root'@'localhost' (using password: YES)" in docker container
Generate CSV based on MySQL query from phpMyAdmin
MYSQL - datetime to seconds

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!