List:General Discussion« Previous MessageNext Message »
From:Michael Dykman Date:June 14 2010 6:04pm
Subject:Re: int(10) va int(11)
View as plain text  
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 Chan <ryanchan404@stripped> wrote:
> 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.mysql.com/mysql?unsub=1
>
>



-- 
 - michael dykman
 - mdykman@stripped

 May the Source be with you.
Thread
int(10) va int(11)Ryan Chan14 Jun
  • Re: int(10) va int(11)Michael Dykman14 Jun
    • Re: int(10) va int(11)Lucio Chiappetti16 Jun
  • RE: int(10) va int(11)Daevid Vincent14 Jun