I remember in MySQL that you can define an integer table field as
AUTOINCREMENT and UNIQUE (I might have the specific keywords wrong, but
everyone will know what I mean).
In the life of a database where there are frequent additions and
deletions, 2^32 isn't that large of a number.
When the integer field reaches 2^32-1 or whatever the upper limit is, what
happens then? Will it try to reuse available values from records that
have been deleted? Or is it always an error?
Thanks, Dave.
-----------------------------------
David T. Ashley (dta@stripped)
Thousand Feet Consulting, LLC
