开发者

am I right understand int(M)?

Can you reply to some of my questions?

  1. If i declare a field int(1) unsigned or int(11) unsigned, in both case I can store from 0 to 4294967295 digit?
  2. int(1) means that I can see only 1 digit of my number in the mysql editor? so with int(11) can I see 11 digit? But if I can store max 4294967295 (10 digit) what mean 11?
  3. 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.


  1. Yes
  2. Integers can be negative, needing a sign
  3. yes
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜