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 ([EMAIL PROTECTED])
Thousand Feet Consulting, LLC


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to