Hi Yemi,

It means the variable contains only positive values - otherwise one
bit would be used to denote whether it's positive or negative. From
the documentation:

SMALLINT[(M)] [UNSIGNED] [ZEROFILL]

A small integer. The signed range is -32768 to 32767. The unsigned
range is 0 to 65535.

Jos

On 4/3/06, Yemi Obembe <[EMAIL PROTECTED]> wrote:
> What does it mean declaring a table unsigned?
> An example is a s below:
>
>  id smallint unsigned not null auto_increment

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

  • Unsigned Yemi Obembe
    • Re: Unsigned Jos Elkink

Reply via email to