Jump to content

Archived

This topic is now archived and is closed to further replies.

Liquid Fire

running out of space?

Recommended Posts

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?

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
And if you use UNSIGNED, you get twice as many.

Share this post


Link to post
Share on other sites
Use UNSIGNED - assuming one db entry per second that gives us 130+ years to solve the problem

Share this post


Link to post
Share on other sites
i guess i never really realized how many entries that is and that i really don't have to worry about it

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.