The 11 is the display width and does not affect the size of values that
can be stored in the column. Here is a quote from
http://www.mysql.com/doc/en/Numeric_types.html:
--BEGIN QUOTE--
As an extension to the ANSI/ISO SQL92 standard, MySQL also supports the
integer types TINYINT,
In the last episode (Jun 10), Mojtaba Faridzad said:
I defined a field as INT type but when I checked in phpMyAdmin, it showed
INT(11). Still I cannot enter higher 2147483647 (signed int) in this field.
Does 11 mean that MySQL needs 11 bytes to keep it? I changed the length to
2 (for example)
.
- Original Message -
From: Mike Hillyer [EMAIL PROTECTED]
To: Mojtaba Faridzad [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003 1:38 PM
Subject: RE: INT type
The 11 is the display width and does not affect the size of values that
can be stored in the column. Here is a quote from
http
At 13:53 -0400 6/10/03, Mojtaba Faridzad wrote:
Thanks Mike and Dan. The link explained everything. but why the manual which
had been installed on my computer ( by downloading and installing mysql 4.0)
is not as complete as the website? anyways, I will look into mysql online
document instead of
In the last episode (Jun 10), Mojtaba Faridzad said:
Thanks Mike and Dan. The link explained everything. but why the
manual which had been installed on my computer ( by downloading and
installing mysql 4.0) is not as complete as the website? anyways, I
will look into mysql online document