In the last episode (Oct 27), D Campbell said:
> quickie: can auto_increment wrap?
>
> I have a system that uses mysql for temporary storage of data. The
> records are kept unique in the usual lazy man's way of having an
> auto_increment ID field.
>
> A large number of records come and go from this database.
>
> At SOME point in the future, the integer value of auto_increment will
> exceed that which can be carried by the largest unsigned integer data
> type available.
If you use a BIGINT AUTO_INCREMENT field as your key, and inserted 5
billion records per second, the field would not roll over for almost 60
years.
Yes, at some point in the future the field will roll over. You don't
have to worry about it, though :)
--
Dan Nelson
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
