Dan Romanchik <mailto:dan at danromanchik.com> on Thursday, July 17, 2003 6:03 PM said: > It definitely does not make sense to have it start over. You could > lose a lot of data that way. Ok so an unsigned int in mysql is 4,294,967,295. I doubt highly that this database even after 3 years of use will ever get near there. (And I don't imagine this will even be used for 3 years.) What does someone do once the limit /is/ reached assuming they didn't use the proper length range in the first place? What would be the next step you take if not to start back at 1? I guess you could just go with an unsigned BIGINT: 18,446,744,073,709,551,615 :) Chris.