corillo181 Posted July 13, 2007 Share Posted July 13, 2007 how do i really use int? whats the maximum value that it can get? like int(11) those that mean that int is going to run 11 spaces until it reach 4294967295??? if I'm expecting a field of id to get a lot of row is this the only one i can use what if it gets more than that value? Quote Link to comment Share on other sites More sharing options...
metrostars Posted July 13, 2007 Share Posted July 13, 2007 INT is usually enough that can go up to 99,999,999,999 or 99 billion, although BIGINT goes bigger, but not sure how high. Quote Link to comment Share on other sites More sharing options...
pocobueno1388 Posted July 13, 2007 Share Posted July 13, 2007 int(11) The 11 means how many characters long the number can be. MySQL will probably throw an error if the number gets large enough that it exceeds that limit. Quote Link to comment Share on other sites More sharing options...
corillo181 Posted July 13, 2007 Author Share Posted July 13, 2007 thank you guys. Quote Link to comment Share on other sites More sharing options...
bubblybabs Posted July 13, 2007 Share Posted July 13, 2007 int(11) The 11 means how many characters long the number can be. MySQL will probably throw an error if the number gets large enough that it exceeds that limit. Yes, that error is 2147483647... I just struggled with that problem myself... Babs 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.