OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: int(10) va int(11)

From: Michael Dykman (mdykmangmail.com)
Date: Mon Jun 14 2010 - 13:04:27 CDT

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 <ryanchan404gmail.com> 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=mdykmangmail.com
>
>

--
 - michael dykman
 - mdykmangmail.com

 May the Source be with you.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql