But did you check if the file size is at 4Gig? This will cause strange things to happen, mysql does not gice a nice error for this condition. If the table was not created with MAX_ROWS option = to some real large number like 500000000000, then you could be running into a problem with the size of the MYD or MYI file. You can use the ALTER statement to add this option to the table. Hope this helps, Ken ----- Original Message ----- From: "Bill Hess" <[EMAIL PROTECTED]> To: "Keith C. Ivey" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, October 08, 2002 4:52 PM Subject: Re: AUTO_INCREMENT max value...
> Not really getting errors but getting warnings when inserting records > and having duplicate values since the primary key is the one that is > auto incremented... > > Keith C. Ivey wrote: > > On 8 Oct 2002, at 12:23, Bill Hess wrote: > > > > > >>What is the maximum value of an AUTO_INCREMENT field? I am currently > >>running into a maximum value of 296,995,724 on Solaris 8 using MySQL > >>3.23.42 - the field has been defined as an INT(11), which should be able > >>to handle a value bigger than what I am seeing - The DuBois MySQL book > >>states it should handle 2^31 which turns out to be 2,147,483,648 > > > > > > What is the error message you're getting? Could it be that the > > problem is the actually size of your data file (over 4 GB?) rather > > than the value of the AUTO_INCREMENT? > > > > [Filter fodder: SQL] > > > > -- > > Bill Hess > Technology Resource Group > > > > -------------------------------------------------------------------- - > 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 > > --------------------------------------------------------------------- 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