Re: Storing negative numbers in AUTO_INCREMENT

2003-06-10 Thread Becoming Digital
ROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, 10 June, 2003 05:42 Subject: Re: Storing negative numbers in AUTO_INCREMENT >I hate to be the one to ask, but what's the subject have to do with the >rest of >the message? I can't see how the two are related at all. They are not

Re: Storing negative numbers in AUTO_INCREMENT

2003-06-10 Thread Egor Egorov
"rich johnson" <[EMAIL PROTECTED]> wrote: > > Short question: I understand that MySQL in some circumstances > may decide that it's faster to do a full table scan rather than use > the index to look up values. > > But I miss some information on *when* this happens. Is there some > way, short of re

Re: Storing negative numbers in AUTO_INCREMENT

2003-06-10 Thread rich johnson
t the list once again with a "sorry, wrong subject" though... - Rich Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: "rich johnson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, 10 June, 2003 04:57 Subject: Storin

Re: Storing negative numbers in AUTO_INCREMENT

2003-06-10 Thread Becoming Digital
: <[EMAIL PROTECTED]> Sent: Tuesday, 10 June, 2003 04:57 Subject: Storing negative numbers in AUTO_INCREMENT Hi, Short question: I understand that MySQL in some circumstances may decide that it's faster to do a full table scan rather than use the index to look up values. But I miss some i

Storing negative numbers in AUTO_INCREMENT

2003-06-10 Thread rich johnson
Hi, Short question: I understand that MySQL in some circumstances may decide that it's faster to do a full table scan rather than use the index to look up values. But I miss some information on *when* this happens. Is there some way, short of reading the source code, that one can get some more det