Can you reply to some of my questions?
- If i declare a field
int(1) unsigned
orint(11) unsigned
, in both case I can store from0 to 4294967295
digit? int(1)
means that I can see only 1 digit of my number in the mysql editor? so withint(11)
can I see 11 digit? But if I can store max 4294967295 (10 digit) what mean 11?- the storage memory is always
4 byte
(if I store, for example, 134 or 4294967295, the space required is the same)?
Tried to read the official Manual, but is开发者_StackOverflow社区 not so clear.
Thanks
Number of digits has sense when you use zerofill attribute for left padding. It doesn't influence the range of values.
Max value available depends even if you use unsigned or not.
- Yes
- Integers can be negative, needing a sign
- yes
精彩评论