Liquid Fire Posted August 3, 2006 Share Posted August 3, 2006 this is not a problem right now and don't think it will be in the furture but just thinking about it. nwo i have a table with a id that is int(10), and none of them can have the same number. i don't know ho wmany possible number are possible with that, i know it is very big, but what happen when i reach the last possible number, what will happen when i try to add one more after that? Quote Link to comment Share on other sites More sharing options...
wildteen88 Posted August 3, 2006 Share Posted August 3, 2006 int can hold upto a maximun of just over 2.1 billion entries - 2,147,483,647 to be exact. If you want to go bigger you can use bigint. Quote Link to comment Share on other sites More sharing options...
fenway Posted August 3, 2006 Share Posted August 3, 2006 And if you use UNSIGNED, you get twice as many. Quote Link to comment Share on other sites More sharing options...
AndyB Posted August 3, 2006 Share Posted August 3, 2006 Use UNSIGNED - assuming one db entry per second that gives us 130+ years to solve the problem Quote Link to comment Share on other sites More sharing options...
Liquid Fire Posted August 3, 2006 Author Share Posted August 3, 2006 i guess i never really realized how many entries that is and that i really don't have to worry about it 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.