On Mon, 14 Jun 2010, Michael Dykman wrote:
11 characters of display allow for any int of any size, signed or
unsigned. When you do not specify a length attribute in a
declaration, MySQL uses 11 as the default.
As an astrophysicist, I've always considered a flaw the fact that mysql
(or SQL in
chan...@gmail.com]
> Sent: Monday, June 14, 2010 9:14 AM
> To: MySql
> Subject: int(10) va int(11)
>
> Assume MySQL int range (unsigned) is from 0 to 4294967295
>
> There are total 10 digits.
>
> Why a lot of tutorial in the web tell you to declare,
>
> e.g.
&g
11 characters of display allow for any int of any size, signed or
unsigned. When you do not specify a length attribute in a
declaration, MySQL uses 11 as the default.
For your application, use what makes sense for your problem's domain.
- michael dykman
On Mon, Jun 14, 2010 at 12:14 PM, Ryan
Assume MySQL int range (unsigned) is from 0 to 4294967295
There are total 10 digits.
Why a lot of tutorial in the web tell you to declare,
e.g.
CREATE TABLE t1 (f INT(11) UNSIGNED);
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists
