dazzclub Posted May 14, 2008 Share Posted May 14, 2008 Hi there, Is there an actual limit to auto_increment at all? Cheers Dazzclub Link to comment https://forums.phpfreaks.com/topic/105582-auto_increment/ Share on other sites More sharing options...
Xurion Posted May 14, 2008 Share Posted May 14, 2008 It depends on your column data type. Link to comment https://forums.phpfreaks.com/topic/105582-auto_increment/#findComment-540864 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 Link to comment https://forums.phpfreaks.com/topic/105582-auto_increment/#findComment-540879 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. Link to comment https://forums.phpfreaks.com/topic/105582-auto_increment/#findComment-540947 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. Link to comment https://forums.phpfreaks.com/topic/105582-auto_increment/#findComment-540970 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... Link to comment https://forums.phpfreaks.com/topic/105582-auto_increment/#findComment-541023 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.