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.
