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 <ryanchan...@gmail.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=mdyk...@gmail.com > > -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
