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.
> --
> MySQL General Mailing List
> For list archives:
> To unsubscribe:

 - michael dykman
 - mdykman@stripped

 May the Source be with you.
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