dazzclub Posted May 14, 2008 Share Posted May 14, 2008 Hi there, Is there an actual limit to auto_increment at all? Cheers Dazzclub Quote Link to comment Share on other sites More sharing options...
Xurion Posted May 14, 2008 Share Posted May 14, 2008 It depends on your column data type. Quote Link to comment Share on other sites More sharing options...
dazzclub Posted May 14, 2008 Author Share Posted May 14, 2008 ive got a table that has over a 3 thousand members. This just house's their name, well their contact details really. I created a login script for these members and they all have the same username and login details. When i was testing i noticed that after a certain point, say after the 2075th member, all the other members after that cant login. the type im using is InnoDB. cheers Dazzclub Quote Link to comment Share on other sites More sharing options...
fenway Posted May 14, 2008 Share Posted May 14, 2008 usually INT UNSIGNED is the way to go... that's about 8 billion. Quote Link to comment Share on other sites More sharing options...
Xurion Posted May 14, 2008 Share Posted May 14, 2008 This ounds more like a code issue to me rather than a database auto_increment issue. Quote Link to comment Share on other sites More sharing options...
fenway Posted May 14, 2008 Share Posted May 14, 2008 This ounds more like a code issue to me rather than a database auto_increment issue. It's unclear as to the source of the error, I agree... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.