Demonic Posted May 5, 2008 Share Posted May 5, 2008 I was looking at this chart and it said length, to make sure I'm correct int(10) can only store a number of the length of 10: like 9,999,999 is the highest number that can be stored? [attachment deleted by admin] Quote Link to comment Share on other sites More sharing options...
rhodesa Posted May 5, 2008 Share Posted May 5, 2008 As far as I know, the 'length' specified after INT is only the width of the display column when running a query from the command line. It has no bearing on min/max values. Quote Link to comment Share on other sites More sharing options...
Demonic Posted May 5, 2008 Author Share Posted May 5, 2008 Alright I think I understand what you are saying. Quote Link to comment Share on other sites More sharing options...
rhodesa Posted May 5, 2008 Share Posted May 5, 2008 I was correct. To confirm I created the following table with one record: CREATE TABLE `test` ( `foobar` INT( 3 ) NOT NULL ); INSERT INTO `skeeter`.`test` (`foobar`) VALUES ('999999'); and was able to select the correct value back out of the table 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.