Also, don't confuse the RANGE of values that the atomtype can be (0-255) if set to be UNSIGNED with the NUMBER OF ROWS in your output. The TINYINT is working. You have no values greater than 255 in there. You just have duplicates which gives you more rows than you were expecting I think. ;-)
> -----Original Message----- > From: Horizon [mailto:[EMAIL PROTECTED]] > Sent: Saturday, January 11, 2003 7:46 PM > To: Mysql List > Subject: unexpected: 260 rows in set on a TINYINT > > > +----------+ > | atomtype | > +----------+ > | 0 | > | 1 | > | 2 | > snip > | 253 | > | 254 | > | 255 | > +----------+ > 260 rows in set (6 min 53.71 sec) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
