It's a BIGINT(25). On Tuesday 21 October 2003 11:58 am, gerald_clark wrote: > Is that a character field? > If it is, you forgot the quotes, and the string was converted to a number. > 16 significant digits match. > > Joakim Ryden wrote: > >Hey folks - > > > >can anyone explain this behaviour: > > > >mysql> select token, spam_hits, innocent_hits from dspam_token_data where > >uid=500 and token=14243385100413148122; > > > >Returns this result, which is a completely different record. > > > >+---------------------------+-------------+----------------+ > > > >| token | spam_hits | innocent_hits | > > > >+---------------------------+-------------+----------------+ > > > >| 14243385100413147136 | 0 | 1 | > > > >+---------------------------+-------------+----------------+ > > > >?? > > > >--Jo > > !DSPAM:3f9581bb310893224619726!
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
