List:General Discussion« Previous MessageNext Message »
From:Rob Wultsch Date:June 3 2008 3:44pm
Subject:Re: integer
View as plain text  
On Tue, Jun 3, 2008 at 4:16 AM, Krishna Chandra Prajapati
<prajapatikc@stripped> wrote:
> Hi,
> How int is eqivalent to int(11)
> Thanks,
> --
> Krishna Chandra Prajapati

" Another extension is supported by MySQL for optionally specifying
the display width of integer data types in parentheses following the
base keyword for the type (for example, INT(4)). This optional display
width is used to display integer values having a width less than the
width specified for the column by left-padding them with spaces.

The display width does not constrain the range of values that can be
stored in the column, nor the number of digits that are displayed for
values having a width exceeding that specified for the column. For
example, a column specified as SMALLINT(3) has the usual SMALLINT
range of -32768 to 32767, and values outside the range allowed by
three characters are displayed using more than three characters. "

Rob Wultsch
integerKrishna Chandra Prajapati3 Jun
  • Re: integerRob Wultsch3 Jun
    • Re: integerKrishna Chandra Prajapati4 Jun