mysql tinyint(1) vs tinyint(2) vs tinyint(3) vs tinyint(4) [duplicate]

TinyINT(M) always has a range from -128..+127 signed or 0..255 unsigned. M is the display width.

M indicates the maximum display width for integer types. The maximum
display width is 255. Display width is unrelated to the range of
values a type can contain, as described in Section 11.2, “Numeric
Types”. For floating-point and fixed-point types, M is the total
number of digits that can be stored.

from http://dev.mysql.com/doc/refman/5.5/en/numeric-type-overview.html

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)