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]