From: Michael Dykman Date: June 14 2010 6:04pm Subject: Re: int(10) va int(11) List-Archive: http://lists.mysql.com/mysql/221903 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable 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 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. > > =A0CREATE TABLE t1 =A0(f INT(11) UNSIGNED); > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: =A0 =A0http://lists.mysql.com/mysql?unsub=3Dmdykman@gmail= .com > > --=20 - michael dykman - mdykman@stripped May the Source be with you.