When you specify an int length in MySQL what does it mean?

[greenace92]

I usually set an ID to 13, does that mean 9999999999999 ? I say 9 as in 0 to 9, I read the manual saying

 

INT 4 -2147483648

2147483647

 

I don't see how that relates, or is it like 2^13 when I specify 13?

[Barand]

http://dev.mysql.com/doc/refman/5.6/en/numeric-type-attributes.html

[Jacques1]

The short version: The display width is irrelevant except for very special cases (like when you use ZEROFILL to pad your numbers with leading zeros).

[greenace92]

Ahh there it is second sentence:

 

 

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.

 

Assuming that Int(4) translates to Int length 4 as seen in phpmyadmin

Edited November 21, 2015 by greenace92

[Jacques1]

Yeah, but do you understand what “length” actually means in this context? It's irrelevant for you (if it was relevant, you'd know).

[greenace92]

 

Yeah, but do you understand what “length” actually means in this context? It's irrelevant for you (if it was relevant, you'd know).

 

I guess I don't based on what you have written, I thought I did.

Edited November 27, 2015 by greenace92