On Mon, 14 Jun 2010, Michael Dykman wrote:
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.
As an astrophysicist, I've always considered a flaw the fact that mysql
(or SQL
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:
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
: Monday, June 14, 2010 9:14 AM
To: MySql
Subject: int(10) va int(11)
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