MySql: Tinyint (2) vs tinyint(1) - what is the difference?
mysql, sqldatatypes
Solution
It means display width
Whether you use tinyint(1) or tinyint(2), it does not make any difference.
I always use tinyint(1) and int(11), I used several mysql clients (navicat, sequel pro).
It does not mean anything AT ALL! I ran a test, all above clients or even the command-line client seems to ignore this.
But, display width is most important if you are using `ZEROFILL` option, for example your table has following 2 columns:
A tinyint(2) zerofill
B tinyint(4) zerofill
both columns has the value of 1, output for column A would be `01` and `0001` for B, as seen in screenshot below :)
Problem
I knew boolean in mysql as `tinyint (1)`. Today I see a table with defined an integer like `tinyint(2)`, and also others like `int(4)`, `int(6)` ... What does the size means in field of type integer and tinyint ?