Bill Hess wrote: > Hello all... > > 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 > > Is there another setting specifc for AUTO_INCREMENT? > If I changed the field's datatype to BIGINT would I be able to achieve > higher values? > Does anyone out there have other techniques they use in place of > AUTO_INCREMENT? > > Please include my direct email when repsonding - Thanks... > Hello,
The maximum value depends on the type of the field. It is 2^31-1 for INT, 2^63-1 for BIGINT. Check the manual for more details: http://www.mysql.com/doc/en/Numeric_types.html Regards, -- Joseph Bueno --------------------------------------------------------------------- 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